Mysql Events

Tag Archives: mysql events

Posted on 27. May, 2009 by Nikhil Sheth.

What are MySQL Events?
Events are just like cronjobs in Linux or or task scheduler in windows.
They are similar to triggers but it fires at particular time or periodically. You have flexibility of setting start date and end date too. MySQL supports Event from version 5.1.6 onwards.

CREATE EVENT [ IF NOT EXISTS ] event_name
ON SCHEDULE schedule
[ [...]