Tag Archives: LOAD DATA example

How To Export and Import of csv data out of and into MySQL This method works for the MySQL 5  and not sure about other versions. Exporting the MySQL data into a comma delimited (.csv) file SELECT * INTO OUTFILE ‘ /data.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ FROM table1; This will dump your table into a file with each row from the database being on it’s own line, columns separated by commas, and … More ->