tags:

views:

17

answers:

2

Hi

Can we map two tables of two different SQL database..

My requirement is i want to move a user contact from one perticular table of MySQL Server 1 to another MySQL Server 2 .

Can we directly map two different tables on two different MySQL Server.

Please suggest me any SQL query to help in this mapping

thanks ratish

A: 

Sounds like replication is the way to go here.

Mark Cooper
A: 

within a query, you can't specify a different database SERVER. however, you can create a FEDERATED table that allows you to query another table on a different server.

longneck