load data local infile 文件路径 into table 表名 lines terminated by 分隔符
例:
load data local infile ‘/root/aa.txt’ into table t lines terminated by ‘\t’;
load data local infile 文件路径 into table 表名 lines terminated by 分隔符
例:
load data local infile ‘/root/aa.txt’ into table t lines terminated by ‘\t’;
转载于:https://www.cnblogs.com/atin/archive/2012/10/30/2746639.html