Re: does mysql alert about all the duplicates?
- Date: Wed, 16 Mar 2016 09:38:26 -0500
- From: Rebecca Love <wacceber@xxxxxxxxx>
- Subject: Re: does mysql alert about all the duplicates?
Maybe this post will help you with your user/config question.
> On Mar 16, 2016, at 7:46 AM, Reindl Harald <h.reindl@xxxxxxxxxxxxx> wrote:
> 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