python - 如何在sqlite中从此循环插入数据

Question

我正在尝试从类似于此的循环中插入数据。

import sqlite3
conn = sqlite3.connect('database.db')
c = conn.cursor()

words = ["apple", "banana", "cherry"]
for word in words:
     c.execute("insert into Words (word), values (?)",(word))
     print(word) 
     conn.commit

c.close()
conn.close()

预期结果类似于:

我收到一个错误。但是我不确定如何正确格式化此代码。

错误:

Traceback (most recent call last):
  File "file.py", line 7, in <module>
    c.execute("insert into Words (word), values (?)",(word))
sqlite3.OperationalError: near ",": syntax error

Answer 1

错误的 list :
commit()不提交，因为它是一个方法
“不插入单词(单词)值(？)”，(单词)，而不是“插入单词(单词)，值(？)”，(单词)

正确的代码是:

import sqlite3
conn = sqlite3.connect('database.db')
c = conn.cursor()

words = ["apple", "banana", "cherry"]
for word in words:
    c.execute("insert into Words (word) values (?)",(word,))
    print(word) 
conn.commit()
conn.close()

别担心，快乐的编码