Skip to content

Instantly share code, notes, and snippets.

@arsu-leo

arsu-leo/Mysql exporting to file from command line

Last active January 10, 2018 08:42
Show Gist options
  • Save arsu-leo/0853fc50d14d22559467cd24c08f029a to your computer and use it in GitHub Desktop.
Save arsu-leo/0853fc50d14d22559467cd24c08f029a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Mysql exporting to file from command line
mysql -u[user] -p[password] -h[host] --database=[database] --batch -e "SQL QUERY FROM X" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > export.csv
@arsu-leo
Copy link
Author

arsu-leo commented Jan 5, 2018

Credits:
https://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format

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