需求:mysql中导入CSV格式的文件,本次导入数据行数为8000多万,CSV文件大小为13.4GB。
导入方式:用工具Navicat的命令行执行命令,命令如下:
LOAD DATA INFILE 'E:/c_ott_qoe/c_ott_qoe_all.csv' INTO TABLE c_ott_qoe FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n';
说明:
Ø 'E:/c_ott_qoe/c_ott_qoe_all.csv' -- CSV文件路径
Ø c_ott_qoe -- 要导入表的表名
Ø FIELDS TERMINATED BY ',' -- 字段分隔符
Ø OPTIONALLY ENCLOSED BY '"' -- 字段包围符
Ø ESCAPED BY '"'
Ø LINES TERMINATED BY '\r\n'; -- 行分隔符