· 9 years ago · Oct 08, 2016, 12:40 PM
1SET GLOBAL event_scheduler = ON;
2
3DELIMITER $$
4CREATE EVENT IF NOT EXISTS EventName
5ON SCHEDULE EVERY 2 MINUTE
6DO
7BEGIN
8
9DELETE FROM Your Table WHERE Your Conditions if Exists;
10
11END$$
12
13DELIMITER ;