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