http://bizadmin.tistory.com/entry/mysql-%EC%9D%B4%EB%B2%A4%ED%8A%B8-%EC%8A%A4%EC%BC%80%EC%A5%B4%EB%9F%AC-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0


http://genesis8.tistory.com/298


http://ellehu.com/mysql/4225



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
블로그 이미지

용병

,