mysql 导入 csv 格式数据

mysql --local-infile -uroot -proot task_ops -e "LOAD DATA LOCAL INFILE '/tmp/data_import/app8.csv' INTO TABLE app_infomation FIELDS TERMINATED BY ',' optionally enclosed by '"' escaped by '"' LINES TERMINATED BY ' '"

原文地址:https://www.cnblogs.com/yako/p/6306053.html