does mysql alert about all the duplicates?

2016-03-18 Thread 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/co

Re: update, insert ... gee.. a puzzle

2016-03-18 Thread Hal.sz S.ndor
2016/03/17 12:47 ... lejeczek: .. that you experts I hope can crack like a digestive biscuit... how does one update, or merge or whatever is right technical term for it - a my.table from my.another table (both are schematically identical, no foreign keys, one primary key) but.. does it a way so

Re: does mysql alert about all the duplicates?

2016-03-18 Thread Reindl Harald
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 f

Re: need help from the list admin

2016-03-18 Thread Chris Knipe
Blah blah blah... Delivery to the following recipient failed permanently: mysql@lists.mysql.com Technical details of permanent failure: Your message was rejected by the server for the recipient domain lists.mysql.com by lists-mx.mysql.com. [137.254.60.71]. The error that the other server r