MySQL Forums
Forum List  »  General

insert and select in between 2 database servers
Posted by: Khan Olid Mannan
Date: February 04, 2010 07:27AM

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.

Options: ReplyQuote


Subject
Written By
Posted
insert and select in between 2 database servers
February 04, 2010 07:27AM


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.