sqlite> select * from sample;
sqlite> insert into sample values('abc',100);
sqlite> insert into sample values('def',200);
sqlite> select * from sample;
abc|100
def|200
sqlite> begin;
sqlite> insert into sample values('ghi',300);
sqlite> select * from sample;
abc|100
def|200
ghi|300
sqlite> rollback;
sqlite> select * from sample;
abc|100
def|200
sqlite>