>>> import sqlite3
>>> c = sqlite3.connect(r'c:\test.sqlite')
>>> cur = c.cursor()
>>> cur.execute('create table test1(id number auto increment primary key, f1 text, f2 text, f3 text)')
<sqlite3.Cursor object at 0x006961A0>
>>> cur.execute('create table test2(id number, f1 text, f2 text, f3 text)')
<sqlite3.Cursor object at 0x006961A0>
>>> query_a = "INSERT INTO test1 (f1, f2, f3) VALUES (?, ?, ?)"
>>> a = [('1', '2', '3')]
>>> cur.executemany(query_a,a)
<sqlite3.Cursor object at 0x006961A0>
>>> cur.execute('select last_insert_rowid()')
<sqlite3.Cursor object at 0x006961A0>
>>> cur.fetchone()
(1,)