阅读背景:

cursor.lastrowid最后一个插入的id

来源:互联网 
#!/usr/bin/<a href="/go.html?url=https://lib.csdn.net/base/11" class='replace_word' title="Python知识库" target='_blank' style='color:#df3434; font-weight:bold;'>Python</a> # import <a href="/go.html?url=https://lib.csdn.net/base/14" class='replace_word' title="MySQL知识库" target='_blank' style='color:#df3434; font-weight:bold;'>MySQL</a> module import MySQLdb # get user input name = raw_input("Please enter a name: ") # connect conn = MySQLdb.connect(host="localhost", user="nobody", passwd="nobody", conn="qestar", unix_socket="/tmp/mysql.sock") # create a cursor cursor = conn.cursor() # execute SQL statement cursor.execute("INSERT INTO test (nama) VALUES (%s)", name) # get ID of last inserted record 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 conn.commit() cursor.lastrowid跟conn.insert_id()的结果一般情况下是一样的,最后一条记录肯定就是刚刚插入的记录。但如果是并发插入就不一样了,多线程的时候 #!/usr/bin/<a href="/go.html?url=https://lib.csdn



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: