# 顯示為ON則已開(kāi)啟
SHOW VARIABLES LIKE 'event_scheduler';

set global event_scheduler=1;

CREATE PROCEDURE `del_data_count`(IN date_inter INT)
BEGIN
DELETE FROM alarminfo
WHERE
(TO_DAYS(NOW()) - TO_DAYS(alarmTime))>=date_inter; # 當(dāng)前系統(tǒng)時(shí)間減去表的時(shí)間字段名
END

# 創(chuàng)建事件
CREATE EVENT `del_tbl_expired_data`
# 表示創(chuàng)建時(shí)間定時(shí)周期，以及開(kāi)始時(shí)間，該處表示從明天1點(diǎn)從開(kāi)始，每天執(zhí)行一次該任務(wù)
ON SCHEDULE EVERY '1' DAY STARTS DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 1 DAY), INTERVAL 1 HOUR)
# 表示創(chuàng)建后并不開(kāi)始生效
ON COMPLETION PRESERVE DISABLE
# 執(zhí)行存儲(chǔ)過(guò)程，刪除30天之前的數(shù)據(jù)
DO CALL del_data_count (30);

# 查看已有定時(shí)事件任務(wù)
SHOW EVENTS; 
# 開(kāi)啟事件
alter event event_name on completion preserve enable;
# 關(guān)閉事件
alter event event_name on completion preserve disable;

SHOW VARIABLES LIKE 'event_scheduler';

SET GLOBAL event_scheduler = ON;

CREATE EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule
?[ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE] [COMMENT 'comment']

?DO sql_statement;?

use database_name;
create event table_truncate on schedule every 60 second do truncate table operator_record_log;

use database_name;
create event table_truncate on schedule every 2592000 second do delete from operator_record_log where create_date < DATE_SUB(CURDATE(),INTERVAL 30 DAY);

use database_name;
create event table_truncate on schedule at timestamp '2022-01-01 00:00:00' do truncate table operator_record_log;

use database_name;
create event table_truncate on schedule every 1 day starts '2022-01-01 00:00:00' do truncate table operator_record_log;

alter event event_name disable;

alter event event_name enable;

drop event if exists event_name;

show events;