插入失败“OperationalError：没有这样的列”

我尝试使用我尝试修复的姓名和电话创建一个数据库，但它会随时向我重播：

File "exm0.py", line 14, in <module>
    cursor.execute("""INSERT INTO Employee VALUES({0}, {1})""".format(k, v))
sqlite3.OperationalError: no such column: dani

Code:

from user_names import *
import sqlite3

# user_names.py
names = ["dani", "eric", "dinna", "tamir", "edan", "daniel", "tomer", 
"noa", "shalev", "tom", "shir"]
phones = ["0432", "5415166255", "61467254", "6146758", "5889482"]

connection = sqlite3.connect("")
cursor = connection.cursor()


cursor.execute("""CREATE TABLE Employee(Name text, Phone int)""")
acc = {}

for k, v in zip(names, phones):
    #acc[k] = v
    cursor.execute("""INSERT INTO Employee VALUES({0}, 
{1})""".format(k, v))

不要进行字符串格式化，而是使用带有占位符的准备好的语句。

for k, v in zip(names, phones):
    #acc[k] = v
    cursor.execute("INSERT INTO Employee VALUES(?, ?)", (k, v))

你甚至不需要循环，你可以使用executemany迭代方法：

cursor.executemany("INSERT INTO Employee VALUES(?, ?)", zip(names, phones))