event-schedular-in-mysql-devzone

Event Scheduler in MySQL is like a task scheduler which performs database related tasks in MySQL. Event scheduler is available in MySQL version > MySQL 5.1.12.
To use event scheduler, first it should be set ON for your database server either in my.ini or my.cnf file. Even you can enable it on run time by using either of following:

SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;

A general syntax is as follows:

An example of Event:

To check any running event or details of event, following query will be used:

Some more examples of Events:

REFERENCES: https://dev.mysql.com/doc/refman/5.1/en/events-configuration.html