csv文件导入数据库

use ip;

load data infile 'E:/ip-to-country.csv' into table `ip-to-country-isp` fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';

CREATE TABLE `ip-to-country-isp` (
  `start` bigint(20) default NULL,
  `end` bigint(20) default NULL,
  `country` varchar(11) default NULL,
  `country2` varchar(11) default NULL,
  `des` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

select * from ip-to-country-isp 
into outfile 'E:/ip-to-country-isp.csv' 
fields terminated by ',' optionally enclosed by '"' escaped by '"' 
lines terminated by '\r\n';