Thanks all,
this looks exactly like what i'm looking for.
However, when I create the federated table, it says it was successful but
creates the table as Myisam.
CREATE TABLE `petestdb.backup_pp_line_code` (
`catalog_id` int(10) unsigned NOT NULL,
`line_code` char(3) NOT NULL,
On 4/28/06, P. Evans [EMAIL PROTECTED] wrote:
Thanks all,
this looks exactly like what i'm looking for.
However, when I create the federated table, it says it was successful but
creates the table as Myisam.
CREATE TABLE `petestdb.backup_pp_line_code` (
`catalog_id` int(10) unsigned NOT
Hello Listers,
Is it possible to run a query on one mysql server to another database on a
different server ?
eg creating an alias in database A on server A to table B on database B on
server B ?
Like a federated nickname on db2 udb or synonym on informix ?
Thanks
Pierre
At 14:38 -0700 4/27/06, P. Evans wrote:
Hello Listers,
Is it possible to run a query on one mysql server to another
database on a different server ?
eg creating an alias in database A on server A to table B on
database B on server B ?
Like a federated nickname on db2 udb or synonym on
On 4/27/06, P. Evans [EMAIL PROTECTED] wrote:
Hello Listers,
Is it possible to run a query on one mysql server to another database on
a different server ?
eg creating an alias in database A on server A to table B on database B on
server B ?
Like a federated nickname on db2 udb or synonym