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]
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.