Get number of modified rows after sqlite3 execute in Python Get number of modified rows after sqlite3 execute in Python sqlite sqlite

Get number of modified rows after sqlite3 execute in Python


After calling your Cursor.execute*() methods with your UPDATE or INSERT statements you can use Cursor.rowcount to see the # of rows affected by the execute call.

If I had to guess I would say the python lib is calling int sqlite3_changes(sqlite3*) from the C API but I have not looked at the code so I can't say for sure.