Mysql: duplicating a table
You need to do :
CREATE TABLE newtable LIKE oldtable; INSERT newtable SELECT * FROM oldtable; |
This creates copy of existing Mysql table with indexes
You need to do :
CREATE TABLE newtable LIKE oldtable; INSERT newtable SELECT * FROM oldtable; |
This creates copy of existing Mysql table with indexes