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>As far as I know the 
    UPDATE query must look like <code>UPDATE table SET (key=value, key2=value2, ...) WHERE &lt;condition&gt;</code></p>

<p>Try to modify query to something like</p>

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

python sqlite3 sql-update