SAVEPOINT与ROLLBACK TO
SAVEPOINT作用是手动设置回滚点,ROLLBACK TO则是回滚到设置的回滚点。
在使用ROLLBACK TO前需要先关闭事务的自动提交
错误:
mysql> savepoint sp;
Query OK, 0 rows affected (0.00 sec)
mysql> rollback to sp;
ERROR 1305 (42000): SAVEPOINT sp does not exist
正确:
mysql> set autocommit = 0;
Query OK, 0 rows affected (0.00 sec)
mysql> savepoint sp;
Query OK, 0 rows affected (0.00 sec)
mysql> rollback to sp;
Query OK, 0 rows affected (0.00 sec)
事务结束时别忘了 手动提交事务:
mysql> commit;
Query OK, 0 rows affected (0.03 sec)