So, every now and then you may want to have a table or some sql query as a csv or excel file to be able to do certain tasks like graphing etc.
Here a quick way to get that.
mysql -h Host -uUser -pPassword -D Database -e 'sql query;' | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" >MyFile.csv
This will create a csv file called MyFile.csv that contains the results from the query “sql query”
As an example, if I have a query say, ‘select * from books where title like “The%”;’, running against a MySQL/mariadb with hostname mydb.local and database items, what we will have is.
mysql -h mydb.local -uUser -pPassword -D items -e 'select * from books where title like "The%";' | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" >MyBooks.csv
If you need this as an excel file, just open with MS excel, make a selection and convert to a table then save as an excel file.