Debian Codegraph @

mysql-test/suite/sys_vars/r/autocommit_func3.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 0
10 SELECT @@autocommit;
11 @@autocommit
12 0
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 set @@global.autocommit = 1-@@global.autocommit;
23 set @@autocommit = 1-@@autocommit;
24 SELECT @@global.autocommit;
25 @@global.autocommit
26 1
27 SELECT @@autocommit;
28 @@autocommit
29 1
30 INSERT into t1(name) values('Record_1');
31 INSERT into t1(name) values('Record_2');
32 SELECT * from t1;
33 id name
34 3 Record_1
35 4 Record_2
36 ROLLBACK;
37 SELECT * from t1;
38 id name
39 3 Record_1
40 4 Record_2
41 DROP TABLE t1;
42 set @@global.autocommit = 1-@@global.autocommit;