[Mysql] procedure, event scheduler Ãß°¡ ½ÇÇà ±¸¹®
-- procedure µî·Ï ±¸¹®
DELIMITER $$
CREATE PROCEDURE ÇÁ·Î½ÃÀú¸í()
BEGIN
DELETE FROM Å×À̺í¸íA;
INSERT Å×À̺í¸íA
SELECT cid
,count(*) AS viewcount
,SYSDATE() AS regdt
FROM Å×À̺í¸íB
WHERE regdt BETWEEN DATE_ADD(SYSDATE(),INTERVAL -12 HOUR) AND SYSDATE()
GROUP BY cid
ORDER BY count(*) DESC,regdt DESC
LIMIT 0,5;
END$$
DELIMITER ;
-- procedure ½ÄÇà ±¸¹®
call ÇÁ·Î½ÃÀú¸í();
-- event scheduler ±¸¹®
CREATE EVENT IF NOT EXISTS DB¸í.À̺¥Æ®½ºÄÉÁì·¯¸í
ON SCHEDULE
EVERY 10 MINUTE -- event scheduler ½ÇÇà °£°Ý(³â,¿ù,ÀÏ,½Ã,ºÐ,ÃÊ)
STARTS '2014-12-30 16:00:00' -- scheduler µî·Ï½Ã°£ +10ºÐ
DO
call DB¸í.ÇÁ·Î½ÃÀú¸í(); -- event scheduler·Î µî·ÏÇÒ Äõ¸®±¸¹®
Ãâó: http://mdj1234.tistory.com/67 [«ŸÀÌ°Å ÈÀÌÆÃ!]