我正在尝试使用 python 函数将一些数据库字段更新到 SQLite DB。我不断收到以下错误:
ValueError: 操作参数必须是 str
下面是我的代码。我很想知道如何更新 sqlite 数据库中的多个列。
def updateEventData():
ID = input('Enter ID of row you\'d like to update: ')
eventname = input('\nPlease enter event name: ')
startdate = input('\nPlease enter event start date: (DD/MM/YYYY): ')
enddate = input('\nPlease enter event end date: (DD/MM/YYYY): ')
venue = input('\nPlease enter event venue: ')
# Sql update
sql = """
UPDATE event_details
SET name, startdate, enddate, venue, (?, ?, ?, ?)
WHERE ROWID = ?
""", (eventname, startdate, enddate, venue, ID)
c.execute(sql)
conn.commit()
最佳答案
您需要单独传递 sql
和参数,而不是作为包含 sql
和参数的元组:
sql = """
UPDATE event_details
SET name, startdate, enddate, venue, (?, ?, ?, ?)
WHERE ROWID = ?
"""
c.execute(sql, (eventname, startdate, enddate, venue, ID))
# ^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
# separated argument, not as a single argument
conn.commit()
见
DB API 2 documentation, Cursor.execute(operation, parameter)
关于python - 值错误 : operation parameter must be str,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/41807577/