Using SQLite

Name

count_changes — Enable change counts for INSERT, UPDATE, and DELETE

Common Usage

PRAGMA count_changes;
PRAGMA count_changes = switch;

Description

The count_changes pragma gets or sets the return value of data manipulation statements such as INSERT, UPDATE, and DELETE. By default, this pragma is false and these statements do not return anything. If set to true, each data manipulation statement will return a one-column, one-row table consisting of a single integer value. This value indicates how many rows were modified by the statement.

The values returned are very similar to those returned by the SQL function changes(), with one small difference. Rows that are modified by an INSTEAD OF trigger on a view will be counted within the statement return value, but will not be counted by changes().

This pragma affects all statements processed by a given database connection.

See Also

changes() [SQL Func, Ap E], sqlite3_changes() [C API, Ap G]