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
ALTER TABLE t1 ADD dummy INT;
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
ALTER TABLE t1 ADD dummy INT;
20
SET GLOBAL command_log_truncate_debug= true;