kymbrik
5/3/2018 - 9:12 AM

How to output MySQL query results in CSV format?

mysql --database=admin --host=127.0.0.1 --port=3309 --user=read --password=123 -B -e "select * from wishlist;" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > /var/tmp/vehicle_categories.csv