+ 1
How to duplicate a table in mysql?
3 Answers
+ 4
This might help you
CREATE TABLE tbl_new AS SELECT * FROM tbl_old;
+ 2
select * into new_table from old_table
+ 1
To copy with structure and data table, use this query:
CREATE TABLE new_table LIKE old_table;
INSERT new_table SELECT * FROM old_table;