并非在SQL语句中使用了所有参数(Python，MySQL) [英] Not all parameters were used in the SQL statement (Python, MySQL)

问题描述

我在以下Python代码上收到错误:

I get an error on the following Python code:

import mysql.connector
cnx = mysql.connector.connect(user='root', password='',
                          host='127.0.0.1',
                          database='DB')
cursor = cnx.cursor()

Name = "James"
Department = "Finance"
StartYear = 2001
CurrentPos = 2001
Link = ""

add_user = ("INSERT INTO DB.tbluser "
       "(username, department, startyear, currentpos, link) "
       "VALUES (%s, %s, %d, %d, %s)")
data_user = (Name, Department, StartYear, CurrentPos, Link)
cursor.execute(add_user, data_user)
cnx.commit()
cursor.close()
cnx.close()

错误消息是

mysql.connector.errors.ProgrammingError: Not all parameters were used in the SQL statement

你知道为什么吗?

推荐答案

参数标记为%s而不是%d.

add_user = """INSERT INTO DB.tbluser 
              (username, department, startyear, currentpos, link) 
              VALUES (%s, %s, %s, %s, %s)"""

请注意，mysql.connector使用的参数标记可能与在Python字符串格式中使用，但关系只是巧合.某些数据库适配器(例如oursql和sqlite3)使用?作为参数标记，而不是%s.

Note that the parameter markers used by mysql.connector may look the same as the %s used in Python string formatting but the relationship is only coincidental. Some database adapters like oursql and sqlite3 use ? as the parameter marker instead of %s.

这篇关于并非在SQL语句中使用了所有参数(Python，MySQL)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！