Search notes:

Python: sqlite3.lastrowid

A cursor's lastrowid attribute returns the last inserted rowid.
#!/usr/bin/python
#
#    cursor.lastrowid returns the last inserted rowid
#
import os
import sys
import sqlite3

db_filename = 'cursor_lastrowid.db'
if os.path.isfile(db_filename):
   os.remove(db_filename)

def ins(a):
    cur.execute('insert into t(a) values (?)', (a, ))
    print('Inserted a record, lastrowid is ' + str(cur.lastrowid))

db = sqlite3.connect(db_filename)
cur = db.cursor()

cur.execute('create table t (id integer primary key, a)')

ins(42)
ins(99)
Github repository about-python, path: /standard-library/sqlite3/cursor_lastrowid.py

See also

sqlite3

Index