Sending an e-mail using linux command

Question

How to email the status of a database transaction

Scenario : "UPDATE xxx SET xxxx=1111 where yyy=111;

I need to trigger a mail the status whether the value got updated in db or not.How can i do it

https://www.google.com/search?q=Sending+an+e-mail+using+linux+command — Karoly Horvath, Jan 21 '15 at 10:38
possible duplicate of [send mail from linux terminal in one line](http://stackoverflow.com/questions/20318770/send-mail-from-linux-terminal-in-one-line) — Karoly Horvath, Jan 21 '15 at 10:39
well, that's actually two questions, post a separate question if the rest is unclear. — Karoly Horvath, Jan 21 '15 at 10:42

score 0 · Answer 1 · edited May 23 '17 at 12:12

There is an way to do both in a single line command, using mysql and mail commands as follows,

mysql -D databasename -u username -p password -e "update xxx set xxxx= 1111 where yyy=111"|mail -s subject your@mail.com

Here is the explanation of above command:

For mysql command

-D [database] : this option is used for selecting database at MySQL.

-u [username] : this option is used for selecting username at MySQL.

-p [password] : this option is used for selecting password at MySQL.

For mail command

-s [subject] : this option is used for subject string.

Reference for mail command.

1 Answers1