我有这样的代码:
my_cursor = my_db.cursor()
def Insert_object(Title, Details, Amount):
sql_command = 'INSERT INTO income (title, details, amount) VALUES (%s, %s, %d)'
values = (Title, Details, Amount)
my_cursor.executemany(sql_command, values)
my_db.commit()
Insert_object('Chips', 'Chili', 12)
,但会抛出以下错误:
mysql.connector.errors.InterfaceError: Failed executing the operation; Could not process parameters
在MySQL文档中,它说executemany
函数的第二个参数是一个元组列表。尝试更改values
,使其成为包含单个元组的列表。
values = [(Title, Details, Amount)]
my_cursor.executemany(sql_command, values)