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 90 10SELECT @@autocommit; 11@@autocommit 120 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 22set @@global.autocommit = 1-@@global.autocommit; 23set @@autocommit = 1-@@autocommit; 24SELECT @@global.autocommit; 25@@global.autocommit 261 27SELECT @@autocommit; 28@@autocommit 291 30INSERT into t1(name) values('Record_1'); 31INSERT into t1(name) values('Record_2'); 32SELECT * from t1; 33id name 343 Record_1 354 Record_2 36ROLLBACK; 37SELECT * from t1; 38id name 393 Record_1 404 Record_2 41DROP TABLE t1; 42set @@global.autocommit = 1-@@global.autocommit; 43