USE test;
drop table if exists t1;
create table t1 (id integer);
set autocommit=0;
begin;
insert into t1 values(1);
commit;
select count(*) from t1;
count(*)
1
drop table t1;