7
7
RENAME TABLE t1 TO t2;
9
DROP TABLE IF EXISTS `t1`;
12
DROP TABLE IF EXISTS `t2`;
15
CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL , PRIMARY KEY (id) );
9
DROP TABLE IF EXISTS `test`.`t1`;
12
DROP TABLE IF EXISTS `test`.`t2`;
15
CREATE TABLE `t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) NOT NULL COLLATE utf8_general_ci, PRIMARY KEY `PRIMARY` (`id`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
18
18
RENAME TABLE t1 TO t2;