On 19 Dec 2002, at 12:19, 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.
You probably want to use "INSERT IGNORE": http://www.mysql.com/doc/en/INSERT.html For some reason "IGNORE" isn't explained on the "INSERT ... SELECT" syntax page, though it is mentioned. [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 --------------------------------------------------------------------- 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