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