#导入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);