Getting the number of affected rows for a SQLite statement using the C API

Question

I'm executing a DELETE statement using the SQLite 3 C API, and I'd like to know how to fetch the number of affected rows.

Unfortunately, there is no function such as sqlite3_affected_rows or similar.

score 19 · Accepted Answer · answered Jul 01 '11 at 18:37

19

Try sqlite3_changes() and/or sqlite3_total_changes()

answered Jul 01 '11 at 18:37

Vinicius Kamakura

7,665
1
29
43

score 8 · Answer 2 · edited Oct 02 '21 at 10:03

8

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)

edited Oct 02 '21 at 10:03

Luc

5,339
2
48
48

answered Feb 20 '21 at 14:38

Hakan

240
3
4

3

You should add some explanations. – hivert Feb 20 '21 at 16:07

Getting the number of affected rows for a SQLite statement using the C API

2 Answers2