1
DROP TABLE IF EXISTS t1, t2;
3
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
4
, padding VARCHAR(200) NOT NULL
6
INSERT INTO t1 VALUES (1, "I love testing.");
7
INSERT INTO t1 VALUES (2, "I hate testing.");
8
REPLACE INTO t1 VALUE (2, "I love testing.");
11
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
12
, padding VARCHAR(200) NOT NULL
15
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
17
, CONSTRAINT fk_t1 FOREIGN KEY (fk_id) REFERENCES t1 (id) ON DELETE CASCADE
19
INSERT INTO t1 VALUES (1, "I love testing.");
20
INSERT INTO t1 VALUES (2, "I hate testing.");
21
REPLACE INTO t1 VALUE (2, "I love testing.");
24
DROP TABLE IF EXISTS `test`.`t1`;
27
DROP TABLE IF EXISTS `test`.`t2`;
30
CREATE TABLE `t1` ( `id` INT NOT NULL AUTO_INCREMENT, `padding` VARCHAR(200) NOT NULL COLLATE utf8_general_ci, PRIMARY KEY `PRIMARY` (`id`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
33
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
36
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
39
UPDATE `test`.`t1` SET `padding`='I love testing.' WHERE `id`=2;
42
DROP TABLE `test`.`t1`;
45
CREATE TABLE `t1` ( `id` INT NOT NULL AUTO_INCREMENT, `padding` VARCHAR(200) NOT NULL COLLATE utf8_general_ci, PRIMARY KEY `PRIMARY` (`id`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
48
CREATE TABLE `t2` ( `id` INT NOT NULL AUTO_INCREMENT, `fk_id` INT NOT NULL, PRIMARY KEY `PRIMARY` (`id`), KEY `fk_t1` (`fk_id`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
51
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
54
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
57
DELETE FROM `test`.`t1` WHERE `id`=2;
58
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I love testing.');
61
DROP TABLE `test`.`t2`;
64
DROP TABLE `test`.`t1`;
66
SET GLOBAL transaction_log_truncate_debug= true;