Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

when a record was inserted can send me a email?

Status
Not open for further replies.

jamiguel77

Programmer
Jun 2, 2005
3
MX
i have a table: table1 with next field: myfield


i want monitoring some data on this field.

is possible: when a value of -555 was inserted on the table: table1 on the field: myfield send me a email?

thanks
 
Mysql cannot send emails. This needs to be done from your back end programming language. Whatever you are using to insert a value into the DB should be what sends the email.



----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech
 
uuuuh...

have some/multiple apps, that caninsert records :)

ok, thanks
 
Depending on how quickly you need to be notified of the entry and assuming you can't alter the scripts inserting the data, you could write a simple script to check the database on a schedule and notify you of any records matching -555.

Hope this helps,

Wullie

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top