首页 > 代码库 > MySQLdb插入后获得插入id

MySQLdb插入后获得插入id

print"ID of last record is ", int(cursor.lastrowid) #最后插入行的主键ID

 

print"ID of inserted record is ", int(conn.insert_id()) #最新插入行的主键ID,conn.insert_id()一定要在conn.commit()之前,否则会返回0