Re: how to merge 2 tables from 2 different database?
No.
The .MRG file needs file path names. The server tries to access the tables via the file system. Not via the network. If you really want to use tables from other machines, you need to mount the foreign file system via NFS or similar.
The UNION clause may perhaps support path names, but it definitely does not support node names or numbers.
Regards
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
28408
May 19, 2006 02:06PM
15396
May 22, 2006 03:56AM
12436
June 01, 2006 11:16AM
12434
June 02, 2006 09:32AM
11876
June 02, 2006 10:10AM
Re: how to merge 2 tables from 2 different database?
10820
June 06, 2006 10:54AM
14790
August 28, 2006 04:10PM
10413
August 30, 2006 10:11AM
15412
September 05, 2006 01:35AM
9053
June 10, 2007 10:05AM
9618
June 21, 2007 01:54AM
9330
June 27, 2007 06:03PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.