oracle savepoint:
begin
savepoint a;
insert into ages values(1,'age');
insert into ages values(1,'age');
insert into ages values(1,'age');
insert into ages values(1,'age11111111111111111111111111');
exception when others then
begin
rollback to a;
end ;
commit;
end ;

mysql savepoint :

start transaction;
savepoint a;
insert into t set id =10;
insert into t set id =21;
insert into t set id =31;
rollback to savepoint a;

start transaction;
set @b=0;
declare continue handler for SQLEXCEPTION set @b=1;
savepoint a;
insert into t set id =10;
insert into t set id =21;
insert into tt set id =31;
if @b=1 then
rollback to savepoint a;
end if;

ITPub博客

mysql & oracle savepoint 使用方法

最新文章