I want to copy table contained from one database and insert onto another database table I want to copy table contained from one database and insert onto another database table mysql mysql

I want to copy table contained from one database and insert onto another database table


If you want to copy a table from one Database to another database , You can simply do as below.

CREATE TABLE db2.table LIKE db1.table;INSERT INTO db2.table SELECT * FROM db1.table;


or just CREATE TABLE db2.table SELECT * FROM db1.table in MySQL 5


In BASH you can do:

mysqldump database_1 table | mysql database_2