with open('TrackPrices.csv','rb') as csvfile:
reader = csv.DictReader(csvfile)
column= [row['price'] for row in reader]
conn = sqlite3.connect('iMusic.db')
c= conn.cursor()
c.execute("UPDATE TRACK set UnitPrice = column")
conn.commit()
conn.close()
我的column是一列和UnitPrice 个数类型一样的数据 想整体替换