MySql批量导入数据

1.创建表tableName

2.导入数据表csv

load data local infile '/home/wangguangzhi/tableName.csv' into table tableName fields terminated by ',';

FIELDS TERMINATED BY ---- 字段终止字符

FIELDS OPTIONALLY ENCLOSED BY ---- 封套符

LINES TERMINATED BY ---- 行终止符（FIELDS TERMINATED BY 'n'）

以上参数跟在紧跟着就好