python sqlite3 UPDATE set from variables
<p>I made next Query to update a row in my DB.</p>

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

<p>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?</p>

<p>You could use this SQL syntax:</p>

<pre><code>UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];
</code></pre>

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

<pre><code>c.execute("UPDATE CATEGORY SET NAME=? WHERE ID=?", (name,category_id))
</code></pre>

<p>WHERE:</p>

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

python sqlite3 sql-update