1drop table if exists t1; 2create table t1 (n int not null primary key) engine=myisam; 3begin work; 4insert into t1 values (4); 5insert into t1 values (5); 6rollback; 7Warnings: 8Warning 1196 Some non-transactional changed tables couldn't be rolled back 9show warnings; 10Level Code Message 11Warning 1196 Some non-transactional changed tables couldn't be rolled back 12show errors; 13Level Code Message 14select @@warning_count,@@error_count; 15@@warning_count @@error_count 161 0 17select * from t1; 18n 194 205 21show warnings; 22Level Code Message 23select @@warning_count; 24@@warning_count 250 26drop table t1; 27