Tod, thanks for your input,
I cannot find this requirement in my help-file for MySQL 3.23.45. I think, it appears in MySQL 4 Anyway, in MySQL 4, one can symlink tables, as described in chapter 5.6.1.2 Using Symbolic Links for Tables Well, well, probably old-fasionated way to acces through DB prefix is the only choice... Thanks again, Dmitry. ----- Original Message ----- From: "Tod Harter" <[EMAIL PROTECTED]> To: "Sergei Golubchik" <[EMAIL PROTECTED]>; "Dmitry Kuznetsov" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 3:19 PM Subject: Re: How to share a MyISAM table among different databases > 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