More than 3 years have passed since last update.

SQLite3のエラー「sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 34 supplied.」の解決方法

Last updated at 2020-07-11Posted at 2020-07-11

エラー内容

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 34 supplied.

c.execute("insert into Ttehai values (?)",(tehai_db))

c.execute("insert into Ttehai values (?)",(tehai_db,))

executeの第二引数にはタプルでないといけないので、項目が1個だけでも「,」が必要になる。