Re: does mysql alert about all the duplicates?
Rebecca Love <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <[email protected]> |
Maybe this post will help you with your user/config question. http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update <http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update> > On Mar 16, 2016, at 7:46 AM, Reindl Harald <[email protected]> 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 > > >