Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


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

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: