Quick way to email results of a mysql query

Is there a simple way to email the results of a mysql query from either the mysql console directly or from the linux开发者_运维技巧 console? Nice formatting is a bonus.

mysql -u .. -p.. -H <<<"your query" | mutt -s 'subject' email@email.com

if you consider HTML is better formatting

personally, i prefer \G

mysql -u .. -p.. -N <<<"your query\G" | mail -s 'subject' email@email.com

Alternative to the other mutt answer is just plain old mail from the mailx package:

mysql -uuser -ppass dbname < queryfile.sql | mail -s 'Your query output' email@example.com

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