Skip to content

Instantly share code, notes, and snippets.

@nojaf

nojaf/export.sql

Created October 29, 2016 09:51
Show Gist options
  • Save nojaf/3bc40918ed58921d64f2cb7cf3e8b6f9 to your computer and use it in GitHub Desktop.
Save nojaf/3bc40918ed58921d64f2cb7cf3e8b6f9 to your computer and use it in GitHub Desktop.
Download ZIP
Export MySQL to csv
Raw
export.sql
SELECT *
FROM my_table
INTO OUTFILE '/var/lib/mysql-files/myfile.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment