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

12 Mar 2019 / by KhanhIceTea

til 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

Sound good ?

Read more
about #til

#TIL : Storing master key inside MacOS keychain

til •

#TIL : Storing master key inside MacOS keychain

#TIL : Run multiple AlpineJS inits and effects on same element

til •

#TIL : Run multiple AlpineJS inits and effects on same element

#TIL : HTML Form no trigger submit when press Enter key on input

til •

#TIL : HTML Form no trigger submit when press Enter key on input

#TIL : Using Curl to check downtime and ssl cert expiration

til •

#TIL : Using Curl to check downtime and ssl cert expiration