insert and select in between 2 database servers
Hi,
I have one MySql Database server in my place and another server in a remote place. What necessary steps i should follow so i can do some 'insert' and 'select' (join) in between two server at the same time?
Example:
1. INSERT into remote_place_server.db1.table1 (id, value)
select id, value from my_place_server.db1.table1;
2. SELECT id, value
from remote_place_server.db1.table1 R
inner join my_place_server.db1.table1 M
ON (R.id=M.id);
I am using MYSql Query Browser.
Subject
Written By
Posted
insert and select in between 2 database servers
February 04, 2010 07:27AM
February 04, 2010 09:17AM
February 04, 2010 02:27PM
February 04, 2010 04:14PM
February 05, 2010 08:39AM
Sorry, you can't reply to this topic. It has been closed.
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.