0
(click on this box to dismiss)
Does CUBRID UPDATE the record if the new value is same as the old one?
As stated in mysql_affected_rows() PHP API manual:
When using UPDATE, MySQL will not update columns where the new value is the same as the old value. This creates the possibility that mysql_affected_rows() may not actually equal the number of rows matched, only the number of rows that were literally affected by the query.
Based on this, how does CUBRID behave when the new value is the same as the old value?
link
comment (0)
accepted answer
asked last year
![[Level:3]](http://www.cubrid.org/modules/point/icons/default/3.gif "Rank: 3/30, reputation score 91 (82% completed for the next level)"){kind=icon}
eye91
1
Answer
1
If you execute an UPDATE query in CUBRID where the new value is the same as the old value, CUBRID Server does not ignore but actually updates the record. Thus, cubrid_affected_rows() function will return 1 instead of 0. See the manual for more information.
![[Level:8]](http://www.cubrid.org/modules/point/icons/default/8.gif "Rank: 8/30, reputation score 558 (28% completed for the next level)"){kind=icon}
dbaasked last year
viewed 588 times