insert ignore into select from
will skip duplicates.
Karl J. Stubsjoen wrote:
>Hello,
>
>How can I determin what erros occur from an "Insert into select from"
>statement? Namely, I'm looking for any duplicate record errors. It is
>important to inform the user (in a web browser) whether or not
Hello,
How can I determin what erros occur from an "Insert into select from"
statement? Namely, I'm looking for any duplicate record errors. It is
important to inform the user (in a web browser) whether or not a particular
insert would fail.
Must I perform a lookup first, or is there a way to