Importer CSV dans Mysql via bash

Mis à jour le 15 janvier 2021 1 min de lecture Historique

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;