1 2 3 4 5 6 7 8 9 10 11 |
CREATE TABLE t1 (a int primary key); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` INT NOT NULL, PRIMARY KEY (`a`) ) ENGINE=InnoDB COLLATE = utf8_general_ci CREATE TABLE t1 (a int primary key); ERROR 42S01: Table 'test.t1' already exists CREATE TABLE t2 (a int primary key, b varchar(20), c bigint); DROP TABLE t1, t2; |