CREATE TABLE LIKE CREATE TABLE t1 (a INT NOT NULL); Query OK, 0 rows affected (0.13 sec) Query OK, 5 rows affected (0.02 sec) CREATE TABLE t2 LIKE t1; Query OK, 0 rows affected (0.10 sec)