HEllo! Is it possible to create a merge table for tables from different databases. I wrote this script for database "collection": CREATE TABLE dict ( url_id int(11) DEFAULT '0' NOT NULL, word varchar(32) DEFAULT '' NOT NULL, intag int(11) DEFAULT '0' NOT NULL, KEY url_id (url_id), KEY word_url (word) ) TYPE=MERGE UNION=(www.url,dbms.url); MySQL took it without any errors. However, when I try to access MERGE table in "collection" database, it fails: -------------------------------------------------- /usr/home/bar > mysql collection Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 210 to server version: 3.23.29a-gamma-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> select * from dict; ERROR 1017: Can't find file: 'dict.MRG' (errno: 2) mysql> --------------------------------------------------- I think this may helps in solving: In /usr/local/mysql/var/collection/dict.MRG I can see this: url url I supposed it should be www.url dbms.url Is that a bug? I suggest this to be fixed in future release. I use 3.23.29a-gamma. Please make a copy to me when replying... Thanks! --------------------------------------------------------------------- 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
