killdash9 killdash9 - 12 days ago 7
Linux Question

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.

Answer
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
Comments