On Thursday 19 December 2002 19: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. No further entries will be inserted. The
> only way I know
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/
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