How to duplicate a table in mysql?

Answer 1

This might help you
CREATE TABLE tbl_new AS SELECT * FROM tbl_old;

Answer 2

select * into new_table from old_table

Answer 3

To copy with structure and data table, use this query:

CREATE TABLE new_table LIKE old_table;
INSERT new_table SELECT * FROM old_table;