Name

total_changes() — Return the total number of rows changed

Common Usage

total_changes( )

Description

The total_changes() function returns an integer that indicates the number of database rows that have been modified by any complete INSERT, UPDATE, or DELETE command run by this database connection since it was opened.

This SQL function is a wrapper around the C function sqlite3_total_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.