How do I get the IDENTITY / AUTONUMBER value for the row I inserted in pymysql

Question

Is possible to get ID for the row I inserted using pymysql?

curr = db.cursor()
curr.execute("INSERT INTO `accounts` (`name`, `password`) VALUES ('%s', '%s')", accName, passwd)
curr.execute("INSERT INTO `person` (`name`, `accoiunt_id`) VALUES ('%s', '%d')", pName, HERE_I_NEED_ACCID)

There is autoincrement primary key "id" in accounts table.

Answer 1

You can use lastrowid property of your cursor object.

Or you can execute SELECT LAST_INSERT_ID(), and fetch the result as scalar with fetchone()