On Sun, Feb 18, 2001 at 12:11:09PM -0800, Jay Habegger wrote:
> MySql Experts:
> I have a mysql server running on host A with database X and a mysql server
> running on host B with database Y.
> In the context of a select I want to JOIN a table in database X on host A
> with a table in database Y on host B. Can this be done? Do I have to do
No, it can't be done. You can join tables in different databases served
by the same server, but not tables served by different servers.
> anything special with the grant tables in either mysql server? If this can
> be done, what is the syntax in the select statement for referencing the
> remote table in database Y on host B (assuming I have a connection handle
> to database X on Host A)?
> Or, is the only way to accomplish my goal to replicate database Y to the
> mysql server on host A?
> Thanks in advance for your help!
> - J
> Jay Habegger
> Bitpipe, Inc.
> 186 Lincoln Street, 5th Floor
> Boston, MA 02111
> T: 617.350.7771 x244
> F: 617.350.7072