Fast way to send mysql query results

Question

Is there an easy way to send mysql query results from mysql console directly or from linux console? Good formatting is a bonus.

Answer 1

mysql -u .. -p.. -H <<<"your query" | mutt -s 'subject' [e-mail] 

if you think HTML formats better

I personally prefer \G

 mysql -u .. -p.. -N <<<"your query\G" | mail -s 'subject' [e-mail] 

Answer 2

An alternative to the other mutt answer is just the old mail from the mailx package:

 mysql -uuser -ppass dbname < queryfile.sql | mail -s 'Your query output' [e-mail] 

Answer 3

 mysql -u <user> -p<password> <database> -e "<query>" | sendmail <emailaddress>