Re: how to merge 2 tables from 2 different database?
Hello,
So if i have 3 databases, on a file system, like so:
/var/lib/mysql/mydb
/var/lib/mysql1/mydb
/var/lib/mysql2/mydb
how would the create be...this is what i have, doesn't seem to work...(this is on the default mysql intance)
create ...
) ENGINE=MERGE UNION=('/var/lib/mysql1/mydb/my_table','/var/lib/mysql2/mydb/my_table');
with or without the quotes...i get a syntax error...specifically ERROR 1103 (42000) at line 357: Incorrect table name
Do i need to somehow define the other 2 dbs to the mysql intance im creating the merge table on? How do i reference the other tables correctly?
I cant find any documentation on this syntax...please point me in the right direction.
Thanks,
L
Edited 1 time(s). Last edit at 08/28/2006 05:43PM by Lionel Farr.
Subject
Views
Written By
Posted
27679
May 19, 2006 02:06PM
14531
May 22, 2006 03:56AM
12087
June 01, 2006 11:16AM
12033
June 02, 2006 09:32AM
11027
June 02, 2006 10:10AM
10406
June 06, 2006 10:54AM
Re: how to merge 2 tables from 2 different database?
13962
August 28, 2006 04:10PM
9996
August 30, 2006 10:11AM
14741
September 05, 2006 01:35AM
8743
June 10, 2007 10:05AM
9187
June 21, 2007 01:54AM
8652
June 27, 2007 06:03PM
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.