Quick way to email results of a mysql query

Question

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.

Answer 1

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

if you consider HTML is better formatting

personally, i prefer \G

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