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