csv文件導(dǎo)入數(shù)據(jù)庫

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';