til

#TIL : Export MySQL data by specified query to CSV file

I learned on 2019-03-12 about cli, mysql

#cli #mysql

To export data from MySQL by specified query to CSV file, you can use this command

$ mysql -B -u username -p database_name -h dbhost -e "SELECT * FROM table_name;" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g"

Tip from : https://stackoverflow.com/a/25427665

Enjoyed this?

Leave a kudo — it means a lot.

0