In Python, after I INSERT Into mysqldb, how do I get the "id"?

Question

The primary key.

cursor.execute("INSERT INTO mytable(height) VALUES(%s)",(height))

My table has 2 columns: 
id << primary, auto increment
height << this is the other column.

How do I get the "id", after I just inserted this?

Answer 1

Use connection.insert_id() to get the ID from the last insert on that connection.

Answer 2

SELECT @@IDENTITY AS 'Identity';

or

SELECT last_insert_id();

Answer 3

Also, cursor.lastrowid (a dbapi/PEP249 extension supported by MySQLdb):

>>> import MySQLdb
>>> connection = MySQLdb.connect(user='root')
>>> cursor = connection.cursor()
>>> cursor.execute('INSERT INTO sometable VALUES (...)')
1L
>>> connection.insert_id()
3L
>>> cursor.lastrowid
3L
>>> cursor.execute('SELECT last_insert_id()')
1L
>>> cursor.fetchone()
(3L,)
>>> cursor.execute('select @@identity')
1L
>>> cursor.fetchone()
(3L,)

cursor.lastrowid is somewhat cheaper than connection.insert_id() and much cheaper than another round trip to MySQL.