goldenboy/gist:1845201

Forked from sr3d/gist:134895

Created February 16, 2012 14:25

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/goldenboy/1845201.js"></script>
Save goldenboy/1845201 to your computer and use it in GitHub Desktop.

Download ZIP

Dump a table to a CSV file

Raw

gistfile1.txt

mysql -h HOST -u USERNAME --password=PASSWORD DATABASE -B -e "SELECT id,email,first_name,last_name,state,zip_code FROM users" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > filename.csv

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