Debian Codegraph @

mysql-test/suite/sys_vars/r/autocommit_func2.result

raw
1 CREATE TABLE t1
2 (
3 id INT NOT NULL auto_increment,
4 PRIMARY KEY (id),
5 name varchar(30)
6 ) ENGINE = INNODB;
7 SELECT @@global.autocommit;
8 @@global.autocommit
9 1
10 SELECT @@autocommit;
11 @@autocommit
12 1
13 INSERT into t1(name) values('Record_1');
14 INSERT into t1(name) values('Record_2');
15 SELECT * from t1;
16 id name
17 1 Record_1
18 2 Record_2
19 ROLLBACK;
20 SELECT * from t1;
21 id name
22 1 Record_1
23 2 Record_2
24 set @@global.autocommit = 1-@@global.autocommit;
25 set @@autocommit = 1-@@autocommit;
26 SELECT @@global.autocommit;
27 @@global.autocommit
28 0
29 SELECT @@autocommit;
30 @@autocommit
31 0
32 INSERT into t1(name) values('Record_1');
33 INSERT into t1(name) values('Record_2');
34 SELECT * from t1;
35 id name
36 1 Record_1
37 2 Record_2
38 3 Record_1
39 4 Record_2
40 ROLLBACK;
41 SELECT * from t1;
42 id name
43 1 Record_1
44 2 Record_2
45 DROP TABLE t1;
46 set @@global.autocommit = 1-@@global.autocommit;