SAVEPOINT

• MySQL

(8.0.22)
drop table tab1;
create table tab1(col1 int);

start transaction;

insert into tab1 values(1);

savepoint sp1;

insert into tab1 values(2);

rollback to sp1;

commit;

select * from tab1;

 

• Oracle

(19c)

drop table tab1 purge;
create table tab1(col1 int);

insert into tab1 values(1);

savepoint sp1;

insert into tab1 values(2);

rollback to sp1;

commit;

select * from tab1;

 

• PostgreSQL

(13)
drop table tab1;
create table tab1(col1 int);

start transaction;

insert into tab1 values(1);

savepoint sp1;

insert into tab1 values(2);

rollback to sp1;

commit;

select * from tab1;

• SQL Server

(2019)

set xact_abort off

drop table tab1;
create table tab1(col1 int);

begin transaction;

insert into tab1 values(1);

save transaction sp1;

insert into tab1 values(2);

rollback transaction sp1;

commit;

select * from tab1;