MySQL Forums
Forum List  »  Federated Storage Engine

CONNECTION syntax to connect two or more remote tables
Posted by: srinivas mokkarala
Date: May 16, 2006 12:47PM

I am attempting to connect a FEDERATED table to more than one remote table. Here is what I'm trying:

--> Table T1 on remote Host-1, running MySQL-5.0
--> Table T2 on remote Host-2, running MySQL 5.0
--> Table T0 on local host, using MySql-Max and FEDERATED engine

Is this possible? If so, please let me know what is the correct syntax of the CONNECTION statement within the create table DDL.

Thanks,
Srinivas Mokkarala



Edited 1 time(s). Last edit at 05/16/2006 12:48PM by srinivas mokkarala.

Options: ReplyQuote


Subject
Views
Written By
Posted
CONNECTION syntax to connect two or more remote tables
7640
May 16, 2006 12:47PM


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.