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 -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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