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.

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.