sqlite3 插入数据问题

Question

使用Python的sqlite3插入数据时报错

错误如下
Traceback (most recent call last):
  File "test.py", line 22, in <module>
    cursor.execute('insert into words (id, word, mean) values (%d, \'%s\', \'%s\')' %(i, word_a, mean_a))
sqlite3.OperationalError: near "f": syntax error

代码的22行如下
cursor.execute('insert into words (id, word, mean) values (%d, \'%s\', \'%s\')' %(i, word_a, mean_a))

问题是我的代码里并没有“f”，求大佬指点迷津。

Answer 1

print("insert into words (id, word, mean) values (%d, '%s', '%s')" % (i, word_a, mean_a))

打出来看看，把报错那句话打出来， 我估计是word_a或者mean_a中有英文单引号造成的，
可以写成下面的样子

cursor.execute('insert into words (id, word, mean) values (?, ?, ?)', (i, word_a, mean_a))
# 或者
cursor.execute('insert into words (id, word, mean) values (:id, :word, :mean)', {"id": i, "word": word_a, "mean": mean_a})

参考https://docs.python.org/3/lib...

Answer 2

改成这样试试：cursor.execute("insert into words (id, word, mean) values (%d, '%s', '%s')" %(i, word_a, mean_a))