Mysql导入csv数据的几种方法

linux下：

LOAD DATA INFILE '/tmp/fanhao.csv'
INTO TABLE ip_location
CHARACTER SET utf8
FIELDS TERMINATED BY ',' ENCLOSED BY '"';
--CHARACTER SET ：mysql字符集，一定要加上，免去乱码麻烦
--INTO TABLE ：导入到哪个表
--FIELDS TERMINATED BY ：以什么作为分割符
-- ENCLOSED BY ：被什么包围

windows：

LOAD DATA INFILE "d:/fanhao.csv"
REPLACE INTO TABLE DEMO
CHARACTER SET gb2312
FIELDS TERMINATED BY "," ENCLOSED BY ""
LINES TERMINATED BY "rn";
--LINES TERMINATED BY：这个与linux不同，以什么作为一行的结尾。