Debian Codegraph @

mysql-test/suite/sys_vars/inc/autocommit_func2.inc

raw
1
2 CREATE TABLE t1
3 (
4 id INT NOT NULL auto_increment,
5 PRIMARY KEY (id),
6 name varchar(30)
7 ) ENGINE = INNODB;
8
9 SELECT @@global.autocommit;
10 SELECT @@autocommit;
11 INSERT into t1(name) values('Record_1');
12 INSERT into t1(name) values('Record_2');
13 SELECT * from t1;
14 ROLLBACK;
15 SELECT * from t1;
16
17 set @@global.autocommit = 1-@@global.autocommit;
18 set @@autocommit = 1-@@autocommit;
19 SELECT @@global.autocommit;
20 SELECT @@autocommit;
21 INSERT into t1(name) values('Record_1');
22 INSERT into t1(name) values('Record_2');
23 SELECT * from t1;
24 ROLLBACK;
25 SELECT * from t1;
26
27 DROP TABLE t1;
28 set @@global.autocommit = 1-@@global.autocommit;