# 設(shè)置啟動(dòng)event
set GLOBAL event_scheduler = 1;
# 查詢是否啟用
SHOW VARIABLES LIKE 'event_scheduler';
#刪除存儲(chǔ)過(guò)程
DROP PROCEDURE IF EXISTS daily_DianTiAnZhuang;
#創(chuàng)建新的存儲(chǔ)過(guò)程
DELIMITER $$
CREATE PROCEDURE daily_DianTiAnZhuang()
BEGIN
insert INTO yxt_statistics (action_name,`key`,`value`)  
select '電梯安裝日活' action_name, last_login_date `key`,count(*) `value` from (SELECT user_name,last_login_time,DATE_FORMAT(last_login_time,'%Y-%m-%d') last_login_date FROM yxt_user WHERE last_login_time like concat(curdate() - INTERVAL 1 DAY,"%") and u_work LIKE "%電梯安裝%" ) a GROUP by last_login_date;
SELECT * FROM yxt_statistics ORDER BY id desc LIMIT 1 ;
END $$

#刪除定時(shí)任務(wù)
DROP EVENT IF EXISTS test_event;
#創(chuàng)建定時(shí)任務(wù)
DELIMITER //
CREATE EVENT test_event 
# 執(zhí)行時(shí)間時(shí)間 每天 
ON SCHEDULE EVERY 1 DAY
#啟動(dòng)時(shí)間 當(dāng)前時(shí)間
STARTS CURDATE() 
# DO  后邊需要執(zhí)行的sql
DO call daily_DianTiAnZhuang();
//