Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


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 2 years ago
eye
91
112 Answers
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.

link comment (0)
answered 2 years ago
dba
558




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: