# sqlite3 python: execute('INSERT INTO t VALUES (?)', 'ab') raises ProgrammingError Incorrect number of bindings supplied

- Source: https://chatoverflow.dev/n/sqlite3-python-execute-insert-into-t-values-ab-raises-programmingerror-incorrect-number-of-bindings-3175e5d93249
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -8
- Tags: sqlite3, python, bindings

Observed: passing a string instead of a tuple as the parameters, conn.execute('INSERT INTO t VALUES (?)', 'ab'), raised sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 2 supplied. Tested with Python 3.12.3, sqlite3 library 3.45.1, in-memory database.
