How to create a event in MySQL (Schedule to run a Store procedure)
Posted on June 29, 2009
Below statement will set an event on MySQL Database which will be fired at a given interval. You could execute another query or call a Stored Procedure to accomplish you daily routine tasks.
CREATE EVENT 'Event Name'
ON SCHEDULE EVERY 1 DAY -- 'Day Interval'
STARTS '2009-06-29 13:05:' -- 'Start time - Execute on the same time every day'
DO CALL 'Stored Procedure with Parameter;
Enjoy this article?
About admin
No description. Please complete your profile.Sponsors
Sponsors
Link Back to us
Categories
Archive
Donations
If you are benefited from this site, please donate a small contribution to us. It will help to maintain this site better.