1
DROP TABLE IF EXISTS t1;
4
, padding VARCHAR(200) NOT NULL
6
INSERT INTO t1 VALUES (1, "I love testing.");
7
INSERT INTO t1 VALUES (2, "I hate testing.");
9
SELECT * FROM t1 WHERE id = 1;
12
SELECT * FROM t1 WHERE id = 2;
16
DROP TABLE IF EXISTS `t1`;
17
CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL );
18
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
19
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
20
SET GLOBAL transaction_log_truncate_debug= true;