Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how many rows affected in sqllite

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.
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #rows #affected #sqllite
ADD COMMENT
Topic
Name
9+7 =