MySQL Forums
Forum List  »  PHP

MySQL Query on two different servers
Posted by: Jérome GOUDEAU
Date: March 14, 2017 11:03AM

Hi,

Queries with joins on tables from two distinct databases work fine, as long as the databases use the same server.

SELECT fields
FROM base1.table1 INNER JOIN base2.table2 ON key1 = key2


How should I proceed when the databases are set on two distinct servers ?

thank you,

Options: ReplyQuote


Subject
Written By
Posted
MySQL Query on two different servers
March 14, 2017 11:03AM


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.