5
5
, padding VARCHAR(200) NOT NULL
7
7
INSERT INTO t1 VALUES (1, "I love testing.");
8
8
INSERT INTO t1 VALUES (2, "I hate testing.");
11
11
, padding VARCHAR(200) NOT NULL
13
13
INSERT INTO t2 SELECT * FROM t1;
14
15
DROP TABLE IF EXISTS `t1`;
15
18
DROP TABLE IF EXISTS `t2`;
17
24
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
18
27
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
21
33
INSERT INTO `test`.`t2` (`id`,`padding`) VALUES (1,'I love testing.');
22
34
INSERT INTO `test`.`t2` (`id`,`padding`) VALUES (2,'I hate testing.');