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

posted @ 2014-05-10 11:39  李伯波  阅读(204)  评论(0编辑  收藏  举报