[mysql] 이벤트 스케줄러 (event scheduler)
2015. 5. 10. 13:54ㆍ카테고리 없음
[mysql] 이벤트 스케줄러 (event scheduler)
CREATE EVENT IF NOT EXISTS RESET_SCORE
ON SCHEDULE EVERY 1 WEEK
STARTS CURRENT_DATE + INTERVAL 6 - WEEKDAY(CURRENT_DATE) DAY
DO
UPDATE user_profile set score=0;
CREATE EVENT IF NOT EXISTS SETUP_SCORE
ON SCHEDULE EVERY 1 WEEK
STARTS CURRENT_DATE + INTERVAL 0 - WEEKDAY(CURRENT_DATE) DAY
DO
UPDATE user_profile set score=rand()*32574 WHERE pic1 like '%tmp%';
// 0 월 1 화 2 수 ~~~