Skip to content

Instantly share code, notes, and snippets.

@brpaz

brpaz/mysql_export_csv.sh

Forked from JoshuaEstes/gist:6831131
Created November 2, 2014 10:38
Show Gist options
  • Save brpaz/6666182f78c65d973653 to your computer and use it in GitHub Desktop.
Save brpaz/6666182f78c65d973653 to your computer and use it in GitHub Desktop.
Download ZIP
mysql export table into CSV file #mysql #csv
Raw
mysql_export_csv.sh
mysql -u USERNAME -p DATABASE -e "select * from TABLE;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment