does mysql alert about all the duplicates?

[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?

many thanks.
L.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

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

[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 when there is a duplicate only NULLs in my.table get
updated/replaced with proper values from my.another table?

many thanks, specially for actual syntax hints.

Nothing here is easy

My best is INSERT ... SELECT ... ON DUPLICATE KEY UPDATE ...;

INSERT INTO my.table SELECT * FROM my."another table" ON DUPLICATE KEY 
UPDATE /* every single field "f" not in the key thus: */ f = 
IFNULL(my.table.f, my."another table".f);


By the way, there always is only one primary key. Maybe you mean that 
there is only one field to it?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: does mysql alert about all the duplicates?

[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
further duplicates?
And is this a user/config controlled behavior?


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






signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[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 returned was:
550 Currently Sending Spam See:
http://www.sorbs.net/lookup.shtml?5.200.22.158


Show me one site, where that IP is, or WAS ever blacklisted?


--
Chris.




On Fri, Mar 18, 2016 at 3:52 PM, Johan De Meersman 
wrote:

>
> and yet, both of those messages made it through :-p
>
> Stick your domain in http://mxtoolbox.com to see if there's any problems
> that might be worth solving. If the mailserver classifies you as spam,
> that's usually caused by something on your side :-)
>
> - Original Message -
> > From: "Chris Knipe" 
> > To: "Lentes, Bernd" 
> > Cc: "MySql" 
> > Sent: Friday, 18 March, 2016 14:46:26
> > Subject: Re: need help from the list admin
>
> > Ditto.  I've pretty much given up on this list...
>
> --
> Unhappiness is discouraged and will be corrected with kitten pictures.
>



-- 

Regards,
Chris Knipe