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)