weixin_50495113的博客

原创 提问：关于mysql中是否rollback的条件判断问题

SET AUTOCOMMIT=0； START TRANSACTION INSERT INTO Customers(cust_id) VALUES (11111); SAVEPOINT StartOrder; INSERT INTO Order(order_num) VALUES (20100); IF ROLLBACK SAVEPOINT StartOrder; COMMIT TRANSACTION 这里想在IF里添加判断条件如果上一步的操作报错，则rollback，否则就commit transac