wiki:send_query_result_html_email
Table of Contents
Send query result as html email
Install mutt
apt-get install mutt
example query
mysql --html -uroot -p mydb -e 'select month(timestamp) as "Month", day(timestamp) as "Day" ,count(*) from table1' | mutt -e "set content_type=text/html" -s 'Mysql daily report' user@email.org
Tested on
- Debian 8
See also
References
wiki/send_query_result_html_email.txt · Last modified: 2021/04/30 13:18 by antisa