20
20
INSERT INTO t1 VALUES (2, "I hate testing.");
21
21
REPLACE INTO t1 VALUE (2, "I love testing.");
23
24
DROP TABLE IF EXISTS `t1`;
24
27
DROP TABLE IF EXISTS `t2`;
25
30
CREATE TABLE t1 ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , padding VARCHAR(200) NOT NULL ) ENGINE=InnoDB;
26
33
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
27
36
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
28
39
UPDATE `test`.`t1` SET `padding`='I love testing.' WHERE `id`=2;
30
45
CREATE TABLE t1 ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , padding VARCHAR(200) NOT NULL ) ENGINE=InnoDB;
31
48
CREATE TABLE t2 ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , fk_id INT NOT NULL , CONSTRAINT fk_t1 FOREIGN KEY (fk_id) REFERENCES t1 (id) ON DELETE CASCADE ) ENGINE=InnoDB;
32
51
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
33
54
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
34
57
DELETE FROM `test`.`t1` WHERE `id`=2;
35
58
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I love testing.');
38
66
SET GLOBAL transaction_log_truncate_debug= true;