Skip to content

Instantly share code, notes, and snippets.

@Navds

Navds/sql_snippets.md

Created December 21, 2018 16:10
Show Gist options
  • Save Navds/08a3b093b0d9e2253a3e37535cf947fd to your computer and use it in GitHub Desktop.
Save Navds/08a3b093b0d9e2253a3e37535cf947fd to your computer and use it in GitHub Desktop.
Download ZIP
Cool sql snippets
Raw
sql_snippets.md

Export query result to csv

mysql -hhost -uuser -ppassword database -e "select query" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > output_file.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment