python mysql in 参数,并非在SQL语句中使用了所有参数（Python，MySQL）

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()

The error message is

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

Do you understand why?

解决方案

The parameter marker is %s not %d.

add_user = """INSERT INTO DB.tbluser

(username, department, startyear, currentpos, link)

VALUES (%s, %s, %s, %s, %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.