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!
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
