MySQL中是否允许嵌套事务？

InnoDB

SAVEPOINTS

您可以执行以下操作：

CREATE TABLE t_test (id INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;START TRANSACTION;INSERTINTO    t_testVALUES  (1);SELECt  *FROM    t_test; id---  1SAVEPOINT tran2;INSERTINTO    t_testVALUES  (2);SELECt  *FROM    t_test; id---  1  2ROLLBACK TO tran2;SELECt  *FROM    t_test; id---  1ROLLBACK;SELECt  *FROM    t_test; id---