主要是关键字:savepoint
SET autocommit = 0;#开启事务
START TRANSACTION;
编写sql语句
DELETE FROM account WHERE id=1;
SAVEPOINT a; #设置保存点
DELETE FROM account WHERE id=2;
#结束事务
#commit;
ROLLBACK TO a; #回滚到保存点
主要是关键字:savepoint
SET autocommit = 0;#开启事务
START TRANSACTION;
编写sql语句
DELETE FROM account WHERE id=1;
SAVEPOINT a; #设置保存点
DELETE FROM account WHERE id=2;
#结束事务
#commit;
ROLLBACK TO a; #回滚到保存点