Question

我正试图用手法将价值观纳入一个数据库,但我刚刚赢得了工作。样本如下:

clist = []
clist.append("abc")
clist.append("def")
clist.append("ghi")
cursor.executemany("INSERT INTO myTable(data) values (?) ", clist)

This gives me the following error:

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

然而,当我改变名单时,该名单行文如下:

clist = ["a", "b"]
cursor.executemany("INSERT INTO myTable(data) values (?) ", clist)

它按照预期发挥作用。我可以在数据库中看到数据。为什么第一个清单不可行,第二个清单不可行?

(PS:这只是一个样本,而不是实际代码。) 我对简便做了小的测试。

Answer 1

根据我所知的处决,你指的是,

clist = [("abc", ), ("def", ), ("ghi", )]
cursor.executemany("INSERT INTO myTable(data) values(?)", clist)

类似情况。不用引用我的话说, for子在 app子里使用,但你需要les子(更一般是可变的)。

你们所看到的错误是,它试图通过你再次提供的每一项手段来振兴你,这样你的发言就象:

clist = [( a ,  b ,  c ), ( d ,  e ,  f ), ( g ,  h ,  i )]

I don t know what your second query is trying to accomplish, but it appears to address a different table, so I m guessing off of no schema info, but if you change the single character strings to multicharacter strings, it will fail too.

Answer 2

仅补充背景: 在密切相关的情况下,我打算在一个表格中插入一个多图清单,使用<代码>executemany。因此:

res = [("John", "2j4o1h2n"), ("Paula", "lsohvoeemsy"), ("Ben", "l8ers")]

cur.executemany("INSERT INTO users (user, password) VALUES (?)", res)

具体检查在某个时间(single? para-substitution in the VALUES field)并把它分为其封装特性(<username> <password>, in this case),它没有sqlite3.Prograig Error exception>>>>>。现有说明使用1,并提供2份<代码/代码>,以及预期在中单独替换。因此,它规定:



cur.executemany("INSERT INTO users (user, password) VALUES (?, ?)", res)


这是一个三边的例子,但might混淆了一点,我希望它可以帮助那些 st的人。

友情链接