Skip to content

Instantly share code, notes, and snippets.

@btbytes

btbytes/mysql_csv.sql

Created March 8, 2010 20:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save btbytes/325722 to your computer and use it in GitHub Desktop.
Save btbytes/325722 to your computer and use it in GitHub Desktop.
Download ZIP
exporting to CSV from mysql
Raw
mysql_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