Hi,

I've been trying to construct a MERGE table in MySQL from about 5000
other tables, each of which have a few thousand entries. However, when
I create and try and access it, I keep getting the dreaded error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near ....

I've read the docs, and am using the same table type (MyISAM), and all
the table columns of each of the 5000 tables is exactly the same. Each
table has a primary key called 'id', and when I try and create the
merge table, I use

INDEX(id)

to specify the index, not making it a primary key.

I'm sure my MySQL syntax is correct; I'm wondering if there are any
additional procedures I need to go through before this. For instance,
do I need to re-order or ammend the indexes of the other tables before
I merge them?

I'm just wondering if other people know of any obscure reasons that
cause problems when creating merge tables.

Many Thanks
Regards
Neil.