Linking tables across MySQL servers
Posted by:
t p
Date: July 04, 2006 04:46PM
Hi,
Is there a way I can link 2 (or more) tables in queries in a scenario where one table is in one database/schema on one MySql server and the second table is in another schema on a second Mysql server (different machine) ?
Sort of:
Select * from server1.schema1.table1 t1, server2.schema2.table2 t2
where t1.fld = t2.fld
Appreciate any replies.
thx
-tp
Subject
Views
Written By
Posted
6782
November 05, 2004 04:28PM
8454
November 16, 2004 06:39PM
3846
November 17, 2004 07:55AM
3731
November 17, 2004 10:02AM
3439
November 17, 2004 01:15PM
6876
November 17, 2004 01:46PM
3105
November 17, 2004 02:18PM
3392
November 17, 2004 02:41PM
2891
November 17, 2004 03:09PM
3451
December 08, 2004 04:01PM
3207
December 14, 2004 09:20AM
3271
December 14, 2004 09:27AM
3493
December 14, 2004 08:52PM
Linking tables across MySQL servers
6813
July 04, 2006 04:46PM
3756
July 04, 2006 05:02PM
3134
July 06, 2006 03:37PM
3617
July 20, 2006 11:41PM
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.