Skip to content

Instantly share code, notes, and snippets.

@deckerego

deckerego/mysql_csv_export.sh

Created December 6, 2013 16:56
Show Gist options
  • Save deckerego/7828227 to your computer and use it in GitHub Desktop.
Save deckerego/7828227 to your computer and use it in GitHub Desktop.
Download ZIP
To export a data set as a CSV file within the MySQL console
Raw
mysql_csv_export.sh
select * into outfile '/home/username/data/my_table.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED 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