記錄下自己寫的MySQL簡(jiǎn)單存儲(chǔ)過程和定時(shí)任務(wù)
統(tǒng)計(jì)有多少個(gè)app
/*應(yīng)用統(tǒng)計(jì)存儲(chǔ)過程*/
/*輸入?yún)?shù)appStatus：應(yīng)用的狀態(tài)*/
DELIMITER $$
CREATE PROCEDURE `appStat`(IN appStatus int)
BEGIN
declare countNum int;
SELECT
COUNT(*)
INTO countNum FROM
app_info
WHERE
app_info.status = appStatus;
/*統(tǒng)計(jì)結(jié)果插入統(tǒng)計(jì)表*/
insert into app_stats(quantity,stat_time,stat_type,status) values(countNum,now(),1,appStatus);
END$$
DELIMITER ;
統(tǒng)計(jì)定時(shí)任務(wù)
/*應(yīng)用統(tǒng)計(jì)定時(shí)任務(wù)*/
set global event_scheduler =1;/*開啟定時(shí)任務(wù)*/
create event if not exists e_app
on schedule every 1 day starts '2017-01-09 00:00:00' /*每天執(zhí)行一次*/
on completion preserve /*永久有效*/
do call appStat(0); /*調(diào)存儲(chǔ)過程*/
停止和刪除定時(shí)任務(wù)
關(guān)閉定時(shí)任務(wù)：
alter event e_app ON COMPLETION PRESERVE DISABLE;
開啟定時(shí)任務(wù)：
alter event e_test ON COMPLETION PRESERVE ENABLE;
刪除定時(shí)任務(wù)：
DROP EVENT IF EXISTS e_test;
參考文檔：
mysql定時(shí)任務(wù)簡(jiǎn)單例子
我的MYSQL學(xué)習(xí)心得（十） 自定義存儲(chǔ)過程和函數(shù)
MySQL存儲(chǔ)過程
