Re: does mysql alert about all the duplicates?
lejeczek <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <[email protected]> |
thanks Rebecca, I'm looking at this examples and still wonder - how do I insert into my.table select * from my.othertable .... and allow all the updates? Both tables are schematically identical. Seems I cannot get the syntax around it. many thanks On 16/03/16 14:38, Rebecca Love wrote: > 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 >> >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql