Mysql Connector/Python 下的 SQL 语句中的格式化字符串问题?

import pandas as pd
import mysql.connector as cnmsq

try:
    cnkun = cnmsq.connect(user='root',
                          password='123456',
                          host='127.0.0.1',
                          database='dbkun')
except:
    print"failed connect..."

cursor = cnkun.cursor()
aos_query = "SELECT is_accepted_name, accepted_id FROM kun_species WHERE species_name=%s"
acc_query = "SELECT species_family, species_genus, species_name, species_full_name FROM kun_species WHERE species_id=%d"
cursor.execute(aos_query, ('Linaria genistifolia',))
for id, acc_num in cursor:
    print(id)
    cursor.execute(acc_query, (acc_num,))
    print([w for w in cursor])

如上,数据库连接成功之后,执行cursor.excute(acc_query,(acc_num,))时候发生错误,将acc_query%d改为%s则程序可以完全正常的执行,但问题是acc_num本身是int型,为什么acc_query内要用%s而非%d格式化它?
引发的错误:

Traceback (most recent call last):
    ....
    "Not all parameters were used in the SQL statement")
mysql.connector.errors.ProgrammingError: Not all parameters were used in the SQL statement
阅读 9.1k
1 个回答

sql 语句 必须是 字符串啊,

撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题