How do I get the "id" after INSERT into MySQL database with Python?

python mysql database
TIMEX picture TIMEX · Mar 30, 2010 · Viewed 149.8k times · Source

I execute an INSERT INTO statement

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

and I want to get the primary key.

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

Amber picture Amber · Mar 30, 2010

Use cursor.lastrowid to get the last row ID inserted on the cursor object, or connection.insert_id() to get the ID from the last insert on that connection.

Related questions

Bulk insert with SQLAlchemy ORM

Is there any way to get SQLAlchemy to do a bulk insert rather than inserting each individual object. i.e., doing: INSERT INTO `foo` (`bar`) VALUES (1), (2), (3) rather than: INSERT INTO `foo` (`bar`) VALUES (1) INSERT INTO `foo` (`bar`) VALUES (2) INSERT INTO `…

Read More
Switching from SQLite to MySQL with Flask SQLAlchemy

I have a site that I've built with Flask SQLAlchemy and SQLite, and need to switch to MySQL. I have migrated the database itself and have it running under MySQL, but Can't figure out how to connect to the MySQL …

Read More
Connect MySQL with Python 3.6

I'm looking for a library to connect to MySQL with Python 3.6. All libraries I found did only work with older versions of Python. Sadly I can't change to an older Python version because i need some functions, which are introduced …

Read More