(?, ?, ?, ?, ?, ?, ?, ?, ?)", (maths, science, language, law, geography, history,lit, socialsci )) sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 9, and there are 8 supplied. code example
Example: Incorrect number of bindings supplied. The current statement uses 1, and there are 3 supplied.
#You need to pass in a sequence, comma at the end:
cursor.execute('SELECT * FROM TABLE WHERE COL = ?;', (string,))