Importer+CSV+dans+Mysql+via+bash

De GeRgOsNet.

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;
Outils personnels