시스템, 서버/Tip & Tech
mysql scheduler / 스케쥴러
용병
2016. 12. 15. 11:44
http://genesis8.tistory.com/298
example :: every day at 13:00
CREATE EVENT IF NOT EXISTS `session_cleaner_event`
ON SCHEDULE
EVERY 13 DAY_HOUR
COMMENT 'Clean up sessions at 13:00 daily!'
DO
DELETE FROM site_activity.sessions;
CREATE EVENT event1
ON SCHEDULE EVERY '1' DAY
STARTS '2016-12-15 13:00:00' -- should be in the future
DO
-- your statements
END