On 10 Apr 2002, at 12:16, Jeffrey Flowers wrote: > Perhaps having a column in my > database with a serialized, unique record number would be a way to prevent > this in the future?
That would allow you to delete just one of the duplicates (which you also do with LIMIT 1 on your DELETE query), but it might be better to avoid inserting the duplicates in the first place. You could define a unique index on whatever combination of columns must be unique for a record (which in most tables is not going to be all the columns). -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- 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
