如何列印資料庫中添加的記錄總數？在我的例子中，它是 Nation 1 和 Nation 2 的記錄。每個國家有 20 條記錄，所以總共有 40 條記錄，但我只看到 20 條記錄添加了我的代碼 cursor.rowcount（40 條記錄在資料庫中正確輸入）
我試試這個，但不行，它只是告訴我兩個國家之一的記錄數，而不是你們兩個的總數（我想要國家 1 國家 2）：
records_added_Nations = 0
print ("Record inserted successfully", cursor.rowcount)
records_added_Nations = records_added_Nations 1
cursor.close ()
添加的記錄的代碼是這樣的：
#NATION 1
sqlite_insert_query_Nation1 = 'INSERT INTO Nation (Name_Nation) VALUES (?);'
count_Nation1 = cursor.executemany(sqlite_insert_query_Nation1, Values_Nation1)
con.commit()
#NATION 2
sqlite_insert_query_Nation2 = 'INSERT INTO Nation (Name_Nation) VALUES (?);'
count_Nation2 = cursor.executemany(sqlite_insert_query_Nation2, Values_Nation2)
con.commit()
uj5u.com熱心網友回復：
cursor.rowcount每次操作后分配，并總計它們。
#NATION 1
sqlite_insert_query_Nation1 = 'INSERT INTO Nation (Name_Nation) VALUES (?);'
cursor.executemany(sqlite_insert_query_Nation1, Values_Nation1)
count_Nation1 = cursor.rowcount
con.commit()
#NATION 2
sqlite_insert_query_Nation2 = 'INSERT INTO Nation (Name_Nation) VALUES (?);'
cursor.executemany(sqlite_insert_query_Nation2, Values_Nation2)
count_Nation2 = cursor.rowcount
con.commit()
print ("Records inserted successfully", count_Nation1 count_Nation2)
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/341355.html
標籤：Python sql 蟒蛇-3.x 数据库 sqlite