title: sqlite3.OperationalError: near ",": syntax error - Updating Database
body: <p>got the following error when trying to update my database:</p>
  
  <p><code>sqlite3.OperationalError: near ",": syntax error</code></p>
  
  <p>This is the section of code that is creating the error:</p>
  
  <pre><code>cursor.execute("""UPDATE SchoolRecordsTable SET Event, Year, YearGroup, Student, Gender, Result WHERE Event=? and YearGroup=? and Gender=? VALUES(?, ?, ?, ?, ?, ?)""", (event_name, dateyear, year, studentname, gender, student_results, event_name, year, gender))
  
  db.commit()
  </code></pre>
  
  <p>Any ideas as to why it's creating an error? Also, do I need "VALUES(?, ?...)" when updating a database or not? I have tried both with and without but I can't check because of the <em>OperationalError</em>.</p>