0
(click on this box to dismiss)
How many records are affected after REPLACE query is executed?
When REPLACE query is executed in CUBRID how many records are affected?
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
The REPLACE statement first deletes all matching records, if they violate PRIMARY KEY or UNIQUE constraints, and then inserts the new record. Thus this function returns the number of deleted records + the number of inserted records.
![[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 593 times