Copy table structure

CODE

To copy the structure

CREATE TABLE `newtable` LIKE `oldtable`;

To also copy the rows in the newtable..

INSERT `newtable` SELECT * FROM `oldtable`;