事务回滚

ROLLBACK

  1. begin;
  2. insert into user(name,age) values("测试3",40);
  3. rollback;
  4. commit;
  5. select * from user;

SAVEPOINT <name>

  1. savepoint <name>;
    2. rollback to savepoint <name>;
    1. BEGIN;
    2. insert into user(name,age) values("测试1",20);
    3. select * from user;
    4. savepoint insert1;
    5. insert into user(name,age) values("测试2",30);
    6. ROLLBACK TO SAVEPOINT insert1;
    7. select * from user;
    8. commit;