import random
import sqlite3
conn = sqlite3.connect('2.db')
print ("Opened database successfully")
cursor = conn.cursor()
cursor.execute("CREATE TABLE IF NOT EXISTS CODE(ID int(255) NOT NULL PRIMARY KEY,ERANDOMCOD VARCHAR(20) NOT NULL,STATUS int(1) NOT NULL)")
str = ''
char = 'AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz0123456789'
length = len(char)
for keys in range(100):
for v in range(10):
str += random.choice(char)
#插入記錄
cursor.execute("INSERT INTO CODE (ID,ERANDOMCOD,STATUS) VALUES ('%s','%s','%s')",[keys,str,1])
str = ''
conn.commit()
然后無論怎么修改，都會有錯誤，如下：
Traceback (most recent call last):
File "D:/coursework/9.py", line 44, in <module>
cursor.execute("INSERT INTO CODE (ID,ERANDOMCOD,STATUS) VALUES ('%s','%s','%s')",[keys])
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.
Opened database successfully
Process finished with exit code 1
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/100615.html
標籤：疑難問題
上一篇：程式員電腦
下一篇：關于代理