Unix Shell - execute mysql query and send email

Author

execute mysql query and send email

Slasher

2004-03-27, 6:35 am

Hello !

I would like to know if it is possible to execute mysql queries and send
emails with a shell script. And if it's possible, how to do that ?

Mark Daniels

2004-03-28, 5:35 pm

"Slasher" <nomail@nospam.org> wrote in message news:<c43ohl$1n1d$1@biggoron.nerim.net>...
> Hello !
>
> I would like to know if it is possible to execute mysql queries and send
> emails with a shell script. And if it's possible, how to do that ?

mysql -u USERNAME -p PASSWORD -D DATABASE -e "SELECT * FROM TABLE"
Use 'mail' or 'mailx' to send mail from the command line.

Mark