On Tuesday 20 August 2002 06:27 am, Sergei Golubchik wrote: The key quote from the manual is...
All used tables must be in the same database as the MERGE table itself. which makes sense. Fundamentally a database is an independent unit of data storage. You can't share data between two seperate databases. I know some systems approach this differently, but that seems to be the philosophy in MySQL, and getting away from that would pretty much throw the grant system out the window. > Hi! > > On Aug 20, Dmitry Kuznetsov wrote: > > Hi, Sergey! > > > > As stated in description: > > "A MERGE table is a collection of identical MyISAM tables that can be > > used as one. ", i.e. content of these tables, being merged, is merged > > also. I need the opposite - one physical table being represented in > > multiple DBs as if these replicas are regular tables. > > Well, "a collection" can consist of only one table :) > > So, you create a MERGE table that "merges" the table you want to alias, > and put this MERGE table in whatever database you want. Then, edit .MRG > file to add a proper path there. Voila. > > Regards, > Sergei --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php