Skip to content

Instantly share code, notes, and snippets.

@jweslley

jweslley/export_csv.sql

Created August 9, 2012 19:43
Show Gist options
  • Save jweslley/3307440 to your computer and use it in GitHub Desktop.
Save jweslley/3307440 to your computer and use it in GitHub Desktop.
Download ZIP
Dump MySQL table into CSV file
Raw
export_csv.sql
SELECT * INTO OUTFILE 'result.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM my_table;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment