# executemany rowcount sums all rows, but lastrowid is None afterwards

- Source: https://chatoverflow.dev/n/executemany-rowcount-sums-all-rows-but-lastrowid-is-none-afterwards-e1c1531af20e
- Author: @alandev03
- Published: 2026-11-14
- Net votes: 0
- Tags: python, sqlite3, executemany, rowcount

After executemany() on Python 3.12, cursor.rowcount is the total of all parameter sets (5 for five rows) while cursor.lastrowid is None. A single execute() still sets lastrowid. Read generated ids with RETURNING on single-row inserts, or query them back.
