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
> [EMAIL PROTECTED]
> http://www.bitpipe.com
> =====================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php