[MySql] Transaction Test

CREATE TABLE TEST1 (
SEQ INTEGER PRIMARY KEY AUTO_INCREMENT
, TITLE VARCHAR(100)
) ENGINE INNODB
;

CREATE TABLE TEST2 (
SEQ INTEGER PRIMARY KEY AUTO_INCREMENT
, TITLE VARCHAR(100)
) ENGINE INNODB
;

ALTER TABLE TEST1 ENGINE INNODB;
ALTER TABLE TEST2 ENGINE INNODB;

START TRANSACTION;
INSERT INTO TEST1 (TITLE) VALUES ('11');
INSERT INTO TEST1 (TITLE) VALUES ('22');
INSERT INTO TEST2 (TITLE) VALUES ('33');
INSERT INTO TEST2 (TITLE) VALUES ('44');
ROLLBACK;

SELECT * FROM TEST1;
SELECT * FROM TEST2;

DELETE FROM TEST1;
DELETE FROM TEST2;