获取所插入的 ID
获取所插入的 ID详细操作教程
以下实例为学习获取所插入的 ID，具体代码如下：
# Filename : example.py
# Author by : www.lidihuo.com
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="myusername",
passwd="mypassword",
database="mydatabase"
)
mycursor = mydb.cursor()
sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = ("Michelle", "Blue Village")
mycursor.execute(sql, val)
mydb.commit()
print("1 record inserted, ID:", mycursor.lastrowid)
执行以上代码输出结果为：
# Filename : example.py
# Author by : www.lidihuo.com
1 record inserted, ID: 15
