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;
0 Comments