python - 如何获取最近插入行的主键值

Question

import MySQLdb

如何在下面的执行中获取最近插入的行的主键值。

cursor = mysql.cursor()
cursor.execute("""INSERT INTO foos (val1,val2) VALUES (%s,%s)""", (v1, v2))

Answer 1

来自 the docs :

Cursor.lastrowid

This read-only attribute provides the rowid of the last modified row (most databases return a rowid only when a single INSERT operation is performed).