mysql 导入 csv 格式数据

mac2022-06-30  85

 

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'"

转载于:https://www.cnblogs.com/yako/p/6306053.html

相关资源:Bash中使用MySQL导入导出CSV格式数据
最新回复(0)