when a record was inserted can send me a email?

[jamiguel77]

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

 

[vacunita]

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

 

[jamiguel77]

uuuuh...

have some/multiple apps, that caninsert records

ok, thanks

 

[Wullie]

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