MySQL Forums
Forum List  »  Newbie

Multi Database Select
Posted by: vince m
Date: May 24, 2005 03:42PM

Hello,

I am searching for a way to make an SQL request on physically separate databases.

The only informations that I founded are about selecting with somthing like:

SELECT * FROM DB1.TBL, DB2.TBL

but in my case DB1 and DB2 aren't on the same MySql Server...

So I wonder if there is a way to do so -without replicating one of the databases on the other server-.

Thanks in advance for help.

Vince M

PS : the platform used should be APACHE+PHP, the mysql version is up to date (and the same) on both servers.

Options: ReplyQuote


Subject
Written By
Posted
Multi Database Select
May 24, 2005 03:42PM
May 25, 2005 12:19AM


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.