>>>>> "Paul" == Paul DuBois <[EMAIL PROTECTED]> writes:
Paul> ALTER IGNORE this_table ADD PRIMARY KEY (name,time)
They are not null so this works well with a slight modification:
ALTER IGNORE TABLE this_table ADD PRIMARY KEY (name,time)
^
One further question. Will this automatically keep my rows ordered by
the primary key with future inserts?
Thanks for your help,
John Hunter
---------------------------------------------------------------------
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
