python - OperationalError：“in”附近：语法错误

Question

出现错误

"OperationalError: near "in": syntax error" in line 7: conn.execute('INSERT INTO Good_Raw_Data VALUES ({values})'.format(values=(list_)))

conn.execute('INSERT INTO Good_Raw_Data VALUES ({values})'.format(values=(list_)))

OperationalError：“in”附近：语法错误

with open("adult.csv", "r") as f:
    next(f)
    reader = csv.reader(f, delimiter="\n")
    for line in enumerate(reader):
        for list_ in (line[1]):
            try:
                conn.execute('INSERT INTO Good_Raw_Data VALUES ({values})'.format(values=(list_)))
                                
                conn.commit()
            except Exception as e:
                raise(e)

该怎么办？

标签： pythonsql