1
DROP TABLE IF EXISTS t1;
4
, padding VARCHAR(200) NOT NULL
7
INSERT INTO t1 VALUES (1, "I love testing.");
8
INSERT INTO t1 VALUES (2, "I hate testing.");
9
DELETE FROM t1 where id = 1;
11
DROP TABLE IF EXISTS t1;
13
CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL , PRIMARY KEY (id) );
15
INSERT INTO `test`.`t1` (`id`, `padding`) VALUES ("1", "I love testing.");
17
INSERT INTO `test`.`t1` (`id`, `padding`) VALUES ("2", "I hate testing.");
19
DELETE FROM `test`.`t1` WHERE `id` = "1";
20
SET GLOBAL command_log_truncate_debug= true;