0

Copy data from one database table to another in Mysql

sometime you want to copy data from one database to another database that are on same server.The columns and tables got diverse name and wanna insert column data from one database to another using mysql query.if you want same thing then following code if for you.


insert data from one database to another, insert data from one table to another in different database, insert into from another server, mysql copy table from one database to another database, select data from one database and insert into another mysql, select from one database and insert into another mysql

Suppose you have 2 database cmp1, cmp2 and table name companies1, companies2 And your task is to insert data from second database table to first database table.The tables columns are different.

First DB: cmp1.companies1

NameAddressEmailPhone

Second DB: cmp2.companies2

NmAddsemailPh

If you want to apply some condition on your query then you easily can.

Leave a Reply

Your email address will not be published. Required fields are marked *