Sqlite3 - Update table using Python code - syntax error near %s
I believe Python's SQLite implementation uses ?
placeholders, unlike MySQLdb's %s
. Review the documentation.
cursor.execute("""UPDATE tasks SET task_owner = ? ,task_remaining_hours = ?,task_impediments = ?,task_notes = ? WHERE task_id= ? """,
(new_task_owner,new_task_remaining_hours,new_task_impediments,new_task_notes,task_id))