List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 19 2001 12:16am
Subject:Re: JOINing Tables Across MySql Servers
View as plain text  
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!
> 
> Regards,
> 
> - J
> =====================================
> Jay Habegger
> CEO
> Bitpipe, Inc.
> 186 Lincoln Street, 5th Floor
> Boston, MA 02111
> T: 617.350.7771 x244
> F: 617.350.7072
> habegger@stripped
> http://www.bitpipe.com
> =====================================
Thread
JOINing Tables Across MySql ServersJay Habegger18 Feb
  • Re: JOINing Tables Across MySql ServersPaul DuBois19 Feb