How To Send Email From MySQL Server?

Asked Jun 16 '11 at 08:34

Active Jun 16 '11 at 08:37

Viewed 377 times

Possible Duplicate:
How to send email from MySQL 5.1

i need to send email from mysql server, i create event Like This

 SET GLOBAL event_scheduler = ON;
DROP EVENT IF EXISTS TestEvent;
CREATE EVENT TestEvent
    ON SCHEDULE every 1 DAY DO
      //SEND Email;

I know it is not a good idea but i need to do it

edited May 23 '17 at 12:23

Community

asked Jun 16 '11 at 08:34

Hiyasat

3

also [how to send email by using triggers in mysql?](http://stackoverflow.com/q/3805166) – Pekka Jun 16 '11 at 08:37
thanks for fast reply, where to set my SMTP authentication? – Hiyasat Jun 16 '11 at 08:40

0 Answers0