#导入txt到mysql

load data local infile 'c:/phone.txt'

into table phone

fields terminated by '\t'

lines terminated by '\r\n'

(pref, phone, province,city,isp,post_code,city_code,area_code);

#导入csv到mysql

load data local infile 'c:/phone.csv'

into table  phone

fields terminated by ',' 

optionally enclosed by '"'

escaped by '"' 

lines terminated by '\r\n'

(pref, phone, province,city,isp,post_code,city_code,area_code);