At 12:19 -0500 12/19/02, Andrew Kuebler wrote:
When I run an INSERT. SELECT query and I am inserting the records into a new table that has a UNIQUE key, the statement will fail as soon as it hits a "Duplicate entry" error. No further entries will be inserted. The only way I know to get around this is to pull the entire column(s) into memory and insert them back in one by one with a repeating INSERT statement. Can anyone tell me the "easy" way to do this? (I assume there must be a better way) Thanks!
Either use INSERT IGNORE or REPLACE, depending on whether you want to ignore subsequent duplicates or use them to replace earlier duplicates.
Andrew
--------------------------------------------------------------------- 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