janmejai/export mysql table in CSV form

Created August 15, 2016 17:41

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/janmejai/2b62f04fc4408fe0358fe99ab7853501.js"></script>
Save janmejai/2b62f04fc4408fe0358fe99ab7853501 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

export mysql table in CSV form

mysql -u username -p databasename -B -e "select * from tablename;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > tablename.csv

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