1
DROP TABLE IF EXISTS t1, t2;
3
id INT NOT NULL PRIMARY KEY
6
id INT NOT NULL PRIMARY KEY
9
INSERT INTO t1 VALUES (1);
10
INSERT INTO t2 VALUES (1);
13
UPDATE t1 SET id=2 WHERE id=1;
14
UPDATE t2 SET id=2 WHERE id=1;
17
DELETE FROM t1 WHERE id=2;
18
DELETE FROM t2 WHERE id=2;
22
DROP TABLE IF EXISTS `test`.`t1`;
25
DROP TABLE IF EXISTS `test`.`t2`;
28
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
31
CREATE TABLE `test`.`t2` ( `id` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
34
INSERT INTO `test`.`t1` (`id`) VALUES (1);
35
INSERT INTO `test`.`t2` (`id`) VALUES (1);
38
UPDATE `test`.`t1` SET `id`=2 WHERE `id`=1;
39
UPDATE `test`.`t2` SET `id`=2 WHERE `id`=1;
42
DELETE FROM `test`.`t1` WHERE `id`=2;
43
DELETE FROM `test`.`t2` WHERE `id`=2;
46
DROP TABLE `test`.`t1`;
49
DROP TABLE `test`.`t2`;
51
SET GLOBAL transaction_log_truncate_debug= true;