Question

How to get record (row) inserted ID from the last INSERT INTO MySQL database table with Python

Answer 1

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
   
import mysql.connector
   
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="python_database"
)
  
db_cursor = db.cursor()
  
sql = "INSERT INTO workers (first_name, profession) VALUES (%s, %s)"
val = ("R2D2", "Super Programmer")
 
db_cursor.execute(sql, val)
 
db.commit()
 
print("last record inserted id:", db_cursor.lastrowid)

'''
run:
 
last record inserted id: 5

'''

 

70+ SQL courses for beginners and professionals