wMdqA3FG

1DROP TABLE IF EXISTS t_test;
2CREATE TABLE t_test (id INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
3
4BEGIN;
5INSERT INTO t_test VALUES  (1);
6SELECT  * FROM t_test;
7
8BEGIN;
9INSERT INTO t_test VALUES (2);
10 SELECT  * FROM t_test;
11
12COMMIT;
13
14SELECT * FROM t_test;
15ROLLBACK;
16SELECT  * FROM t_test;