Re: Maintaining a UNIQUE INDEX in a MERGED Table

2003-01-01 Thread Benjamin Pflugmann
Hello. On Wed 2003-01-01 at 15:38:23 -0500, [EMAIL PROTECTED] wrote: > If I am reading the documentation correctly, MySQL will not maintain a > UNIQUE INDEX across the tables that make-up a merged table. Correct. Although it is called a UNIQUE index, the MERGE table doesn't hold it's own index an

Maintaining a UNIQUE INDEX in a MERGED Table

2003-01-01 Thread Andrew Kuebler
If I am reading the documentation correctly, MySQL will not maintain a UNIQUE INDEX across the tables that make-up a merged table. Does anyone have any tips for maintaining a UNIQUE INDEX across tables that make up a merged table? Is there an easier way than running a SELECT statement on all of th