Name

changes() — Get the number of rows changed by the last SQL command

Common Usage

changes( )

Description

The changes() function returns an integer that indicates the number of database rows that were modified by the most recently completed INSERT, UPDATE, or DELETE command run by this database connection.

This SQL function is a wrapper around the C function sqlite3_changes(), and has all of the same limitations and conditions.

See Also

total_changes(), last_insert_rowid(), sqlite3_changes() [C API, Ap G]