LOAD DATA INFILE "路径/test.txt" INTO TABLE test FIELDS TERMINATED BY '@' LINES TERMINATED BY '\n';
上述语句意思为:
将test.txt文件导入到test 表中,约定字段分隔符为'@',行分隔符为'\n'