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
'시스템, 서버 > Tip & Tech' 카테고리의 다른 글
bootstrap modal show/hide (0) | 2016.12.19 |
---|---|
리눅스의 실행 예약 "at" (0) | 2016.12.15 |
Lets' Encrypt로 무료로 HTTPS 지원하기 (0) | 2016.12.14 |
MariaDB >> CJK-ready fulltext search, column store (0) | 2016.12.12 |
공부하기 (0) | 2016.12.11 |