ProgrammingError: Incorrect number of bindings supplied. The current statement uses 4, and there are 5 supplied code example
Example 1: Incorrect number of bindings supplied. The current statement uses 1, and there are 3 supplied.
cursor.execute('SELECT * FROM TABLE WHERE COL = ?;', (string,))
Example 2: sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied.
cursor.execute('INSERT INTO images VALUES(?)', (data))
cursor.execute('INSERT INTO images VALUES(?)', (data,))
len(data)
>>>7
len(data,)
>>>1