CREATE TABLE newdb.mynewtable LIKE olddb.myoldtable;
INSERT newdb.mynewtable SELECT * FROM olddb.myoldtable;
|How do I copy a table from one MySql schema to another mySql schema in MySl?||David Hannes||11/08/2006 12:33PM|
|Re: How do I copy a table from one MySql schema to another mySql schema in MySl?||Anthony Willard||11/08/2006 01:22PM|
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.