How to do duplicate a table of MySQL

Solved

CREATE TABLE table2 LIKE table1;
INSERT INTO table2 SELECT * FROM table1;

Refer

• http://forums.mysql.com/read.php?10,100977,101012#msg-101012
• http://www.plus2net.com/sql_tutorial/sql_copy_table.php