12
id INT NOT NULL PRIMARY KEY
13
13
, padding VARCHAR(200) NOT NULL
15
15
INSERT INTO t1 VALUES (1, "I love testing.");
16
16
INSERT INTO t1 VALUES (2, "I hate testing.");
18
19
DROP TABLE IF EXISTS `t1`;
19
CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL );
21
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
22
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
25
CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL );
26
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
27
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
22
CREATE TABLE t1 ( id INT NOT NULL PRIMARY KEY , padding VARCHAR(200) NOT NULL );
25
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
26
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
32
CREATE TABLE t1 ( id INT NOT NULL PRIMARY KEY , padding VARCHAR(200) NOT NULL );
35
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
38
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
29
43
SET GLOBAL transaction_log_truncate_debug= true;