mysql & oracle savepoint 使用方法

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;