python插入記錄後取得主鍵id的方法(cursor.lastrowid和conn.insert_id())

標籤：結果   name   create   最新   value   sql   int   插入   pre   

#!/usr/bin/python  # import MySQL 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()的結果一般情況下是一樣的，最後一條記錄肯定就是剛剛插入的記錄。但如果是並發插入就不一樣了，多線程的時候

python插入記錄後取得主鍵id的方法(cursor.lastrowid和conn.insert_id())