mysql load csv

-- MYSQL   LOAD DATA INFILE命令可以把csv平面文件中的数据导入到数据库中。-- linux下：LOAD DATA INFILE '/home/test/dump/ip_location.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:/insert_data.csv" REPLACE INTO TABLE DEMO CHARACTER SET gb2312 FIELDS TERMINATED BY "," ENCLOSED BY "" LINES TERMINATED BY "\r\n";-- LINES TERMINATED BY：这个与linux不同，以什么作为一行的结尾。-- txt  或是linuxTRUNCATE TABLE adx_analysis.creative_category_imp_cli_tmp ;LOAD DATA LOCAL INFILE 'D:\\analyst20151231.txt' INTO TABLE  adx_analysis.creative_category_imp_cli_tmp CHARACTER SET utf8;  LOAD DATA INFILE语法LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'    [REPLACE | IGNORE]    INTO TABLE tbl_name    [FIELDS        [TERMINATED BY 'string']        [[OPTIONALLY] ENCLOSED BY 'char']        [ESCAPED BY 'char' ]    ]    [LINES        [STARTING BY 'string']        [TERMINATED BY 'string']    ]    [IGNORE number LINES]    [(col_name_or_user_var,...)]    [SET col_name = expr,...)]