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.

possible duplicate of [How do you safely and efficiently get the row id after an insert with mysql using MySQLdb in python?](http://stackoverflow.com/questions/706755/how-do-you-safely-and-efficiently-get-the-row-id-after-an-insert-with-mysql-usin) — jhonkola, May 07 '14 at 12:03

Imran · Accepted Answer · 2011-07-23T17:29:53.510

15

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()

edited Jul 23 '11 at 17:29

answered Jul 23 '11 at 17:24

Imran

87,203
23
98
131

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

1 Answers1

Linked