python - SQLITE3：更新数据库时出错

Question

def update_data():
    conn = sqlite3.connect('address_book.db')
    c = conn.cursor()
    record_id= delete_box.get()
    c.execute("""UPDATE addresses SET
        first_name = :first,
        last_name = :last,       
        address = :address,
        city = :city,
        state = :state,
        zipcode = :zipcode
        WHERE oid=:oid """,
        {
        'first':f_name_editor.get(),
        'last':l_name_editor.get(),
        'city':city_editor.get(),
        'state':state_editor.get(),
        'zipcode':zipcode_editor.get(),
        'oid':record_id


        })
    conn.commit()
    conn.close()

尝试更新数据库时出现以下错误： c.execute("""UPDATE addresses SET sqlite3.ProgrammingError: You did not provide a value for binding 3.

标签： pythonpython-3.xsqlite

Answer 1

你没有错过address绑定吗？

您没有为绑定 3 提供值。