python - 我怎样才能不出现 mysql 转换元组错误？

Question

我只想使用 UPDATE 命令刷新。这给出了错误，我哪里出错了？

for checkNewAbility in list(newAbilities1):
    if not checkNewAbility in list(oldAbility[1]):
        my_cursor.execute(
           "UPDATE mydb.skill SET skill_name='%s' WHERE Person_person_id='%s' 
                AND skill_id='%d';",(checkNewAbility, url[0], oldAbility[0]))
        realdb.commit()

错误:

"Failed processing format-parameters; %s" % err)mysql.connector.errors.ProgrammingError: Failed processingformat-parameters; Python 'tuple' cannot be converted to a MySQL type

我的列表有:

oldAbility= [(43, 'PHP'), (44, 'HTML'), (45, 'CSS')]

newAbilities1= ['Java', 'Python', 'JavaScript']

I just want to replace oldAbilities with newAbilities1 according to id.

Answer 1

如果您正确地复制并粘贴了代码，则在execute(后缺少双引号“”。我假设您使用pyodbc。

for checkNewAbility in list(newAbilities1):
    if not checkNewAbility in list(oldAbility[1]):
        my_cursor.execute("UPDATE mydb.skill SET skill_name='?' WHERE Person_person_id='?' AND skill_id='?'", (checkNewAbility, url[0], oldAbility[0]))
        realdb.commit()