Why not use cron?

    mysql the_database << "SELECT ...." | mail -s "Daily report" your@email

You can insert some formatter in between if you want. If you'd rather send emails from a proper account and not local mailer, you can use ssmtp and configure a smarthost. (http://www.cyberciti.biz/tips/linux-use-gmail-as-a-smarthost...)