logo标签列表

Mysql事务提交和回滚示例

mysql
3
以下 MySQL 查询出现了以下错误。
查询 -
    set @rollback = 0; 
    start transaction;    
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET @rollback = 1;
    INSERT INTO `tablea` (`date`) VALUES (NOW());
    INSERT INTO `tableb` (`date`) VALUES (NOW());
    INSERT INTO `tablec` (`date`) VALUES (NOW());
    IF @rollback THEN
        ROLLBACK;
    ELSE
        COMMIT;
    END IF;

错误：

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET @rollback = 1' at line 1
这些语句是在存储过程中吗？请参考https://dev59.com/e2Ij5IYBdhLWcg3wxnyd#19908197获取示例。 - wchiquito
1个回答
0
网页内容由stack overflow 提供, 点击上面的
可以查看英文原文，
原文链接