Import CSV file directly into MySQL:

直接下MYSQL指令 先建立資料表以及欄位,再匯入scv檔案:

load data local infile 'D:/AppServ/www/test/geoip/ip2country/GeoIPCountryWhois.csv' into table tblUserIP fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(uniqName, uniqCity, uniqComments,aname,bname,cname)

 

 

cabuchi 發表在 痞客邦 PIXNET 留言(0) 人氣()