Ok, created the merge table, now I get this error when I log into the mysql server....
[snip] Didn't find any fields in table 'SuperMailbox' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3903 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show columns from SuperMailbox; ERROR 1016: Can't open file: 'SuperMailbox.MRG'. (errno: 143)
[snip]
Any ideas what I've screwed up now?
Thanks,
Jeff
Hmmm...
% perror 143 Error code 143: Unknown error: 143 143 = Conflicting table definitions in sub-tables of MERGE table
Can you post the results for SHOW CREATE TABLE for the tables you're trying to merge?
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
