mysql存储过程

DELIMITER $$
DROP PROCEDURE IF EXISTS article_clickCount_procedure $$

CREATE PROCEDURE article_clickCount_procedure()
BEGIN

DECLARE flag INT DEFAULT 0;
DECLARE articleId INT DEFAULT 0;
DECLARE curArticle CURSOR FOR SELECT id FROM YcArticle;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET flag = 1;
OPEN curArticle;
	FETCH curArticle INTO articleId;
	WHILE(flag !=1) DO
		UPDATE YcArticle SET todayClickCount = 0 WHERE id = articleId;
		FETCH curArticle INTO articleId;
	END WHILE;
END $$    
DELIMITER ;

CREATE EVENT IF NOT EXISTS event_article_clickCount_procedure
ON SCHEDULE EVERY 24 HOUR STARTS CURDATE() + 1
ON COMPLETION PRESERVE
DO CALL article_clickCount_procedure();

SHOW VARIABLES LIKE '%sche%';
SET GLOBAL event_scheduler = 1;

或者在配置文件   my.ini/my.inf中加入
event_scheduler = 1
这种mysql重启之后都会有效，前面一种mysql重启了会失去效用。