Page 1 of 1

how events works in mysql

Posted: Thu Oct 15, 2009 1:48 am
by kushaljutta
i need some information about events in mysql...

my need is i want to send email with php using mysql when the sql time reaches the specified time....is this possible in mysql..

please help me

thanks in advance

Kushal.J

Re: how events works in mysql

Posted: Thu Oct 15, 2009 3:37 am
by jackpf
I've never seen something like this myself...although it may well be possible.

Sounds like you want to use a cron job/scheduled task though.

Re: how events works in mysql

Posted: Thu Oct 15, 2009 3:40 am
by Eran
MySQL can run timed events on itself, but cannot run outside processes such as PHP. Like Jack suggested, you should use a cron job for that.
http://dev.mysql.com/doc/refman/5.1/en/events.html

Re: how events works in mysql

Posted: Tue Oct 20, 2009 5:44 am
by batfastad
On our intranet we have an e-mail reminders system so users can add scheduled task which either pops up on the intranet screen (using jquery timed ajax) or e-mailed to them using a half-hourly cron job and swiftmailer.
It works well but its quite low traffic... 10 e-mail reminders per day on average

HTH