1set autocommit=off;
2drop table if exists t;
3create table t (a int, b int, primary key (a)) engine=innodb;
4start transaction;
5insert into t values (1,2),(2,4),(3,8);
6commit;
7start transaction;
8select * from t;
9a	b
101	2
112	4
123	8
13commit;
14start transaction;
15truncate table t;
16rollback;
17start transaction;
18select * from t;
19a	b
20commit;
21drop table t;
22