Python csv按照行读写入mysql

import csv
import sys,os
import pymysql

if __name__ == "__main__":
    csv_file=open('P:/a.csv')
    csv_reader_lines = csv.reader(csv_file)
    db = pymysql.connect(host="", port=3306,user="",passwd="",db='',charset='utf8')
    cur = db.cursor()
    for row in csv_reader_lines:
        field1=row[0]
        field2=row[1]
        field3=row[2]+";"+row[3]
        prolist=row[4].split("-")
        province = prolist[0]
        city=prolist[1]
        field4=province
        field5=city
        sql='''insert into t_post(post_id,user_id,lmLatLon,province,city) values(%,%,%,%,%) '''.format(field1=field1,field2=field2,field3=field3,field4=field4,field5=field5)
        cur.execute(sql)
    cur.close()
    db.close()