MySQL – Améliorer export et import de données

Exporter des données

SELECT name, age, city INTO OUTFILE '/tmp/data' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; FROM test.people;

Exporte le fichier /tmp/data contenant les champs name, age, city de la table people:

"alexandre","30","paris"
"mark","26","new york"

Importer des données

LOAD DATA INFILE '/tmp/data' INTO TABLE people FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Importe le fichier /tmp/data dans la table people

Benjamin Baudouin