Skip to content

Instantly share code, notes, and snippets.

@meysampg

meysampg/query_to_csv.sh

Created December 28, 2023 22:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save meysampg/7b42790a7a9277802756cadb439606f6 to your computer and use it in GitHub Desktop.
Save meysampg/7b42790a7a9277802756cadb439606f6 to your computer and use it in GitHub Desktop.
Download ZIP
Export a query result to CSV in MySQL
Raw
query_to_csv.sh
$ mysql --default-character-set=utf8 -h $DB_HOST -u $DB_USERNAME -p -e '<QUERY_TO_RUN>' $DB_DATABASE | sed 's/\t/,/g' > <FILENAME>.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment