Copying tables on mysql

Here is a snippet to copy tables (possibly from one database to another):

ipk is a schema, ipk_v2 as another schema. Here I'm trying to copy a table called "tclrequest" from ipk to ipk_v2


USE ipk_v2;CREATE TABLE `table11` LIKE `ipk`.`tclrequest`; -- A temp table 
INSERT INTO tclrequest SELECT * FROM ipk.tclrequest;


You'll need to delete the temp table when you are done.

Comments

Popular posts from this blog

Testing SOAP services using pingdom