Getting the number of affected rows for a SQLite statement using the C API
Run this.
select changes(),total_changes();The changes() function returns the number of database rows that were changed or inserted or deleted by the most recently completed INSERT, DELETE, or UPDATE statement
The total_changes() function returns the number of row changes caused by INSERT, UPDATE or DELETE statements since the current database connection was opened.
(emphasis added)