Quote:
Originally Posted by Old Pedant
Simpler than that:
INSERT IGNORE ...
That's all you need. Don't need the ON DUPLICATE KEY stuff if you just want to ignore the duplication error.
|
Once again, thank you. Followup question. Is there a way to have the query let me know which records it did not insert due to being duplicates. Not really important, just more curiosity on my part.