DELIMITER $$

SET GLOBAL event_scheduler = ON $$

USE `BNS`$$
DROP EVENT IF EXISTS `clearLastUpdated` $$
USE `BNS`$$
CREATE EVENT `clearLastUpdated`
    ON SCHEDULE EVERY 1 HOUR
DO BEGIN
   DELETE FROM testTable WHERE last_updated <=SUBDATE(NOW(3), INTERVAL 1 DAY);
END $$
