Importer CSV dans Mysql via bash

mysql -uroot -p --local-infile

mysql> use mabase;

mysql> LOAD DATA LOCAL INFILE '/root/monfichier.csv' INTO TABLE matable  COLUMNS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\n'  IGNORE 1 LINES;