insert into select query with two databases

0
votes

Any body knows (insert into table1 select * from table2) query with two databases. Mean table1 is in one database and table2 is in second database,I want to insert records from table2 to table1 which have same structure but they resides on different database. Can we do that in PHP or MYSQL?

1
insertmultiple-databases
Connect to one database from PHP, selects the data from the table, connect to the second database, insert those data. You probably can't do this in one go..... - MD Sayem Ahmed

1 Answers

0
votes

Do According To This! Hey Man You Made a New Database? And Want to Transfer All Data from First Database to other? If Yes, Use This:

  1. Open MySql There Will be Export navigation button in horizontal menu just in the middle.

  2. Click it.

  3. Just Click Go Button.

Otherwise man from php its too difficult....