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
how events works in mysql
Moderator: General Moderators
-
kushaljutta
- Forum Commoner
- Posts: 50
- Joined: Fri Dec 26, 2008 11:05 am
Re: how events works in mysql
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.
Sounds like you want to use a cron job/scheduled task though.
Re: how events works in mysql
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
http://dev.mysql.com/doc/refman/5.1/en/events.html
Re: how events works in mysql
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
It works well but its quite low traffic... 10 e-mail reminders per day on average
HTH