Go to mysql command:
Set pager directive:
mysql> pager mail -s “subject” firstname.lastname@example.org
PAGER set to ‘mail’ -s “subject” email@example.com
The trick uses pager directive to redirect the query output result to a mail program rather than displaying on mysql command.
Once above step is done, change database and run your query the query result will be emailed to the given email id