错误：1210:执行prepared statemens的参数数目不正确

Question

我尝试使用Python将数据插入MySQL。在

这个错误的原因是什么？在

ProgrammingError: 1210: Incorrect number of arguments executing prepared statement

我的python代码：

connection = mysql.connector.connect(host='localhost',
                         database='popsww2017',
                         user='root',
                         password='')
records_to_insert = [('---2q7vcZGU', 'Partner-provided', '35', '9s1Pvm0U8Gg8mRavZhVXdg', 'A663893851990558', '1066/2016/HDHT-Pops-Kha Ly', '1467', '0.100598')]
sql_insert_query = "INSERT INTO raw_music (`Video_ID`, `Content_Type`, `Video_Duration`, `Channel_ID`, `Asset_ID`, `Asset_Labels`, `Owned_Views`, `Partner_Revenue`) VALUES ( '%s', '%s' , '%s' , '%s', '%s' , '%s' , '%s' , '%s') "
cursor = connection.cursor(prepared=True)
result  = cursor.executemany(sql_insert_query,records_to_insert)
connection.commit()

我的桌子：

^{pr2}$

Answer 1

您忘记传递executemany method parameters：

result  = cursor.executemany(sql_insert_query,records_to_insert)

MySQLCursor.executemany() Method Syntax:

cursor.executemany(operation, seq_of_params)

This method prepares a database operation (query or command) and executes it against all parameter sequences or mappings found in the sequence seq_of_params.

另外，您的语法错误（删除引号），请使用以下内容：

^{pr2}$