mysql获取最后一次插入的id:
python代码示例:
conn = getmysqlconn(connstr, use_pool)
try:
cursorclass = conn.cursor(cursor=pymysql.cursors.Cursor)
with cursorclass as cursor:
cursor.execute(sql)
cursor.execute('SELECT LAST_INSERT_ID();')
result = cursor.fetchone()
conn.commit()
return result[0]
finally:
conn.close()
语句是:
SELECT LAST_INSERT_ID();