====== Duplicate table and data in MySql ======
Use the following SQL code to duplicate table structure:

<code>CREATE TABLE newtable LIKE oldtable;</code>

And if you need the same data in the new table (for testing?), copy the data with this SQL code:

<code>INSERT INTO newtable SELECT * FROM oldtable;</code>