Skip to content

Instantly share code, notes, and snippets.

@seabre

seabre/export_table_as_csv_from_mysql.md

Created April 4, 2012 18:55
Show Gist options
  • Save seabre/2304737 to your computer and use it in GitHub Desktop.
Save seabre/2304737 to your computer and use it in GitHub Desktop.
Download ZIP
Export Table as CSV From MySQL
Raw
export_table_as_csv_from_mysql.md

#Export Table as CSV From MySQL

SELECT * INTO OUTFILE '/tmp/my_table_name.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM my_table_name;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment