Re: MERGE table across InnoDB tables?

2004-02-24 Thread Eric B.
According to the docs http://www.mysql.com/doc/en/MERGE.html: A MERGE table (also known as a MRG_MyISAM table) is a collection of identical MyISAM tables that can be used as one. The disadvantages with MERGE tables are: You can only use identical MyISAM tables for a MERGE table. I have neve

MERGE table across InnoDB tables?

2004-02-24 Thread John McCaskey
I attempted to create a merge table across two identical InnoDB tables and it seemed to work without error. But when I went to use the table I got a file not found my_table.MRG (error number 2) error. The file does in fact exist, but it is only 54 bytes. I'm guessing that I can only create a