CONNECTION syntax to connect two or more remote tables
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.
Subject
Views
Written By
Posted
CONNECTION syntax to connect two or more remote tables
7640
May 16, 2006 12:47PM
3757
May 16, 2006 06:56PM
7020
May 17, 2006 12:27AM
3441
June 18, 2006 12:51AM
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.