import codecs
import dataset
db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/google_poi?charset=utf8mb4')
table=db['lat_lon_loc']
fr=codecs.open('lat_long_location.csv','r','utf-8')
lines=fr.readlines()
for l in lines[1:]:
    newl=l.strip()
#    print(newl)
    elmts=newl.split(',')
    table.insert({'num':elmts[0],'loc':elmts[1],'lat':elmts[2],'lon':elmts[3]})
#print(lines)
fr.close()