affected row count

The number of rows an INSERT, UPDATE or DELETE actually changed, reported back to the program that ran it.

In more detail

Checking it turns a silent failure into a signal: zero rows from a conditional update means someone else changed the row first, or it no longer exists. SQLite reports it through the changes() function.

Related terms

Taught in

References