2020-12-02 向mysql 导入txt格式的数据

load data local infile "/root/data/e_investment100_20201202_102254.txt" replace  into table e_inv_investment100 fields  terminated by ',' lines terminated by '\n';
load data local infile "/root/data/e_inv_person100_20201202_102103.txt" replace  into table  e_inv_person100 fields  terminated by ',' lines terminated by '\n';
load data local infile "/root/data/e_pri_person100_20201202_102336.txt" replace into table  e_pri_person100 fields  terminated by ',' lines terminated by '\n';

需要注意的地方是 文件路径 要用引号引起来