Web lists-archives.com

Re: does mysql alert about all the duplicates?

Am 16.03.2016 um 13:38 schrieb lejeczek:
hi everybody

just another beginner's question.
if I insert into table and there are duplicate primary keys - does mysql
alert about all the duplicates or just the first one and then
exits/abandon the rest of the insert without any alerts for potential
further duplicates?
And is this a user/config controlled behavior?

only the first because it makes no sense when you attempt to make 1000000 inserts proceed the whole operation when in the second one a fatal error happens

Attachment: signature.asc
Description: OpenPGP digital signature