MySQL_事务_回滚

Savepoint 保存点；设置保存点

SET autocommit = 0;
START TRANSACTION;
DELETE FROM account
WHERE id = 25;
SAVEPOINT a;#设置保存点
DELETE FROM account
WHERE id = 28；
ROLLBACK TO a；#回滚到保存点

SELECT * FROM account；

#28：是回滚到的保存点处。所以不会被删除。
#而25会被删。