Mysql insert into on duplicate key same value

Question

When I update a value in Mysql the affected rows is 0 when the value to be updated is the same as the new value, otherwise it is 1. What is the value of affected rows, when I use insert on duplicate key update in this situation. Is it 0 or is it 2? I can't find it in the docs.

Nzall · Accepted Answer · 2013-10-23 12:00:50Z

1

If your database supports duplicate keys, there will be 1 row affected. If your database does not support it, you will get an error.

edit: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html since I misunderstood the question.

edited Oct 23, 2013 at 12:00

answered Oct 23, 2013 at 11:41

Nzall

3,5855 gold badges36 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

rsdrsd Over a year ago

I mean "insert ... on duplicate key" query. What i the affected rows value if the updated value is the same as the new value.

Nzall Over a year ago

apologies. dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html explains it, including the affected row count.

Collectives™ on Stack Overflow

Mysql insert into on duplicate key same value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related