How to clone mysql table

To copy just structure and data use this one:

CREATE TABLE Newtable AS SELECT * FROM Oldtable;
Only data copy:
INSERT testdb.Country
SELECT * FROM Master.Country;

Post a Comment

0 Comments