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 <h.rei...@thelounge.net> 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