- savepoint # 设置保存点,并和rollback结合使用,实现回滚到指定保存点
- rollback to # 回滚到指定点
student表:
name | gid |
---|---|
小明 | 1 |
小红 | 2 |
使用:
set autocommit=0;
start TRANSACTION;
DELETE from student where gid=1;
SAVEPOINT a;
DELETE from student where gid=2;
ROLLBACK TO a;
结果:
只有gid等于1的数据删除,gid等于2的数据并没有删除