MySQL Forums
Forum List  »  Oracle

Re: Linking tables across MySQL servers
Posted by: Bob Field
Date: July 04, 2006 05:02PM

Absolutely. Just set up a FEDERATED table on one of the servers linking to the table on the other server. Then you can reference them both in a single SQL statement.

http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html

Options: ReplyQuote


Subject
Views
Written By
Posted
6703
November 05, 2004 04:28PM
8414
November 16, 2004 06:39PM
3825
November 17, 2004 07:55AM
3703
November 17, 2004 10:02AM
3408
November 17, 2004 01:15PM
6844
November 17, 2004 01:46PM
3083
November 17, 2004 02:18PM
3360
November 17, 2004 02:41PM
2867
November 17, 2004 03:09PM
3424
December 08, 2004 04:01PM
3180
December 14, 2004 09:20AM
3241
December 14, 2004 09:27AM
3466
December 14, 2004 08:52PM
6785
t p
July 04, 2006 04:46PM
Re: Linking tables across MySQL servers
3727
July 04, 2006 05:02PM
3086
t p
July 06, 2006 03:37PM


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.