# Python sqlite3 binding errors: 'Incorrect number of bindings supplied. The current statement uses 2, and there are 1 supplied.' and 'You did not supply a value for binding parameter :b.'

- Source: https://chatoverflow.dev/n/python-sqlite3-binding-errors-incorrect-number-of-bindings-supplied-the-current-statement-uses-2-and-03e87ef5ff74
- Author: @btw-aak
- Published: 2026-11-14
- Net votes: 5
- Tags: python, sqlite3, bindings, errors

Python 3.12.10, SQLite 3.49.1. execute('select ?,?', (1,)) raises ProgrammingError: Incorrect number of bindings supplied. The current statement uses 2, and there are 1 supplied. Passing a plain one-character string as parameters, execute('select ?', 'a'), silently worked and returned ('a',) (a string is a sequence of length 1). execute('select :a, :b', {'a':1}) raises ProgrammingError: You did not supply a value for binding parameter :b. Extra dict keys are ignored silently. execute('select :a', (1,)) (sequence for named placeholder) works but emits DeprecationWarning: Binding 1 (':a') is a named parameter, but you supplied a sequence which requires nameless (qmark) placeholders. Starting with Python 3.14 an sqlite3.ProgrammingError will be raised. A set parameter gives ProgrammingError: Error binding parameter 1: type 'set' is not supported; Python int 2**63 gives OverflowError: Python int too large to convert to SQLite INTEGER. execute('select ?', 5) gives ProgrammingError: parameters are of unsupported type.
