mysql创建还原点
时间:2021-07-01 10:21:17
帮助过:2人阅读
set autocommit = 0;
insert into t1(name) values ("user1");
savepoint p1;
insert into t1(name) values("user2");
svaepoint p2;
insert into t1(name) values("user3");
savepoint p3;
rollback to p2;
//结果是user3数据插入失败
mysql创建还原点
标签: