python sqlite3 UPDATE set from variables

Question

I made next Query to update a row in my DB.

def saveData(title, LL, LR, RL, RR, distanceBack):
    c.execute("UPDATE settings SET (?,?,?,?,?,?) WHERE name=?",(title, LL, LR, RL, RR, distanceBack, title))
    conn.commit()

I always get next error: sqlite3.OperationalError: near "(": syntax error I know something isn't correct with the question marks. I can't find out what the exact solution is. Can somebody explain me what the problem is?

Answer 1

You could use this SQL syntax:

UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];

for example, if you have a table called Category and you want to edit the category name you can use:

c.execute("UPDATE CATEGORY SET NAME=? WHERE ID=?", (name,category_id))

WHERE:

Category is a table that contains only two items: (ID, NAME) with ID PRIMARY KEY.