The qickest way to duplicate MySQL table.
CREATE TABLE newtable LIKE oldtable; INSERT newtable SELECT * FROM oldtable;
To just duplicate all structure and data:
CREATE TABLE tbl_new AS SELECT * FROM tbl_old;
×
The qickest way to duplicate MySQL table.
CREATE TABLE newtable LIKE oldtable; INSERT newtable SELECT * FROM oldtable;
To just duplicate all structure and data:
CREATE TABLE tbl_new AS SELECT * FROM tbl_old;
Add new comment