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 and uniqueness is only guaranteed on sub-table
basis (presumed you have the corresponding UNIQUE index on the
sub-tables).
> Does anyone have any tips for maintaining a UNIQUE INDEX across
> tables that make up a merged table?
No. You have to check uniqueness yourself. Or use a procedure that
assures you uniqueness, if possible.
> Is there an easier way than running a SELECT statement on all of the sub
> tables and then inserting the item if all tables return 0 found?
Do the SELECT on the MERGE table instead?
HTH,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
