SELECT*FROM ACCOUNT;SET autocommit =0;STARTTRANSACTION;DELETEFROM ACCOUNT WHERE id =1;SAVEPOINT a;DELETEFROM ACCOUNT WHERE id =2;ROLLBACKTO a;//只会滚到保存点a那个地方
文章目录savepoint 保存点语法 savepoint 节点名样例savepoint 保存点可以让回滚的时候之回滚到保存点这里保存点上面的不回滚语法 savepoint 节点名样例SELECT * FROM ACCOUNT;SET autocommit = 0;START TRANSACTION;DELETE FROM ACCOUNT WHERE id = 1;SAVEPOINT a;DELETE FROM ACCOUNT WHERE id = 2;ROLLBACK TO a;/