dbapi_question.py

import sqlite3
import os

DB_FILENAME = "dbapi_question.sqlite"

os.chdir(os.path.dirname(os.path.realpath(__file__)))
try:
    os.remove(DB_FILENAME)
except:
    pass

# 0. Create DB
db = sqlite3.connect(DB_FILENAME)
db.execute("""
           CREATE TABLE books(
               id integer,
               name text)
           """)
db.execute("""
           INSERT INTO books(id,name) VALUES (1,"Test Name")
           """)
db.commit()


# 1. Works
db.execute("UPDATE books SET name=? WHERE id=?",
           ("Second Name", 1))
db.commit()


# 2. Doesn't work
db.execute("UPDATE books SET ?=? WHERE id=?",
           ("name", "Third Name", 1))
db.commit()


db.close()