存储csv数据到mysql

#!/usr/bin/env python

-- coding: utf-8 -

import csv
import pymysql
conn = pymysql.connect(host=‘localhost’, user=‘root’, password=‘1234’, db=‘danke’, charset=“utf8”)
cursor = conn.cursor()
with open(‘danke.csv’,‘r’,encoding=‘utf-8’)as csvfile:
read = csv.reader(csvfile)
for each in list(read)[1:]:
i=tuple(each)
#print(i)
sql = “insert into danke values” + str(i)
cursor.execute(sql)
conn.commit()
cursor.close()
conn.close()