各位大神好:
我在课本上抄了一段程序,想看看运行结果,运行时却报错,请帮忙查看是什么原因.
代码如下
import sqlite3
def convert(value):
if value.startswith('~'):
return value.strip('~')
if not value:
value = '0'
return float(value)
conn=sqlite3.connect('food.db')
curs=conn.cursor()
curs.execute('''
CREATE TABLE food (
id TEXT PRIMARY,
desc TEXT,
water FLOAT,
kcal FLOAT,
protein FLOAT,
fat FLOAT,
ash FLOAT,
carbs FLOAT,
fiber FLOAT,
sugar FLOAT
)
''')
query='INSERT INTO food VALUE (?,?,?,?,?,?,?,?,?,?)'
for line in open(r'C:\Users\wgh\Downloads\ABBREV.txt'):
fields = line.split('^')
vals=[convert(f) for f in fields[:field_count]]
curs.execute(query,vals)
conn.commit()
conn.close()
报错内容如下:
Traceback (most recent call last):
File "E:/python/Lib/site-packages/importdata.py", line 26, in
''')
sqlite3.OperationalError: near ",": syntax error