Hi. On Tue 2002-08-20 at 10:58:53 +0200, [EMAIL PROTECTED] wrote: > > 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.
But you can have that with MERGE tables: Make them "merge" only one table, e.g. create the real table in a separate database, and in each other database, create a merge table over it, so you effectively get a "live copy". > Although, one may have one master table (with master contents), and > empty tables with the same structure in other DBs. Such an empty > table might be merged over the master table. Yes. Hm. I am not sure if I can follow... I do not see the need or use of empty tables in the context. Regards, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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