我有一个python脚本,应该在sqlite表中插入一个列表。我的插入语句似乎不起作用。
links = ['a', 'b', 'c']
conn = sqlite3.connect('example.db')
#create a data structure
c = conn.cursor()
#Create table
c.execute('''Create TABLE if not exists server("sites")''')
#Insert links into table
def data_entry():
sites = links
c.execute("INSERT INTO server(sites) VALUES(?)", (sites))
conn.commit()
#query database
c.execute("SELECT * FROM server")
rows = c.fetchall()
for row in rows:
print(row)
conn.close
我在命令行检查了数据库,但是“server”表是空的:
C:\App\sqlite\sqlite_databases>sqlite3
SQLite version 3.17.0 2017-02-13 16:02:40
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .tables
server
sqlite> SELECT * FROM server
...> ;
sqlite>
所以看起来并没有真正插入列表。
遍历
list_
并对每个项执行INSERT
。并调用data_entry()
来实际插入数据。相关问题 更多 >
编程相关推荐