mysql命令行导入大文件txt

load data local infile 文件路径 into table 表名 lines terminated by 分隔符

例：

load data local infile ‘/root/aa.txt’ into table t lines terminated by ‘\t’;