1CREATE TABLE t1 2( 3id INT NOT NULL auto_increment, 4PRIMARY KEY (id), 5name varchar(30) 6) ENGINE = INNODB; 7SELECT @@global.autocommit; 8@@global.autocommit 91 10SELECT @@autocommit; 11@@autocommit 121 13INSERT into t1(name) values('Record_1'); 14INSERT into t1(name) values('Record_2'); 15SELECT * from t1; 16id name 171 Record_1 182 Record_2 19ROLLBACK; 20SELECT * from t1; 21id name 221 Record_1 232 Record_2 24set @@global.autocommit = 1-@@global.autocommit; 25set @@autocommit = 1-@@autocommit; 26SELECT @@global.autocommit; 27@@global.autocommit 280 29SELECT @@autocommit; 30@@autocommit 310 32INSERT into t1(name) values('Record_1'); 33INSERT into t1(name) values('Record_2'); 34SELECT * from t1; 35id name 361 Record_1 372 Record_2 383 Record_1 394 Record_2 40ROLLBACK; 41SELECT * from t1; 42id name 431 Record_1 442 Record_2 45DROP TABLE t1; 46set @@global.autocommit = 1-@@global.autocommit; 47