异常未处理:SQL 语句中未使用所有参数

Question

当我运行以下代码时，我收到错误"SQL 语句中未使用所有参数"：

import mysql.connector
from mysql.connector import Error
from pw import * # Imports password from another file
from datetime import datetime

db = mysql.connector.connect(
host="localhost",
user="zac",
passwd= pww,
database="testdatabase"
)
mycursor = db.cursor()

namee = input("What is your name? ")
brandd = input("What laptop brand do you own? ")

# mycursor.execute("CREATE TABLE Laptop (brand varchar(50) NOT NULL, created datetime NOT NULL, id int PRIMARY KEY NOT NULL AUTO_INCREMENT, name varchar(50) NOT NULL)")
mycursor.execute("INSERT INTO Laptop (brand, name) VALUES (%s,%s)", (brandd, datetime.now(), namee))
db.commit()

我的目标是将用户输入保存在服务器中。我不确定错误是什么，因为我很确定我已经涵盖了每个参数。

Answer 1

mycursor.execute("INSERT INTO Laptop (brand, created,name) VALUES (%s,%s,%s)", (brandd, datetime.now(), namee))

您应该具有与您在VALUE之前的括号中放入的列名相同数量的参数(即%s(。