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 '\r\n'"

posted @ 2017-01-19 11:59  梅里之巅  阅读(221)  评论(0编辑  收藏  举报