mysql 事件 Events介绍

最新推荐文章于 2024-08-09 21:25:57 发布

weixin_33755557

最新推荐文章于 2024-08-09 21:25:57 发布

阅读量100

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/taomac/blog/666341

版权

1 查看Events

show events

show full events\G

SELECT * FROM mysql.event;

SELECT * FROM information_schema.events;

2 查看Events是否开启

select @@event_scheduler;

show variables like 'event_scheduler';

3 开启Events 方法

set GLOBAL event_scheduler=ON;

set GLOBAL event_scheduler=1;

4 删除Events方法

DROP EVENT first_event;

5 事件编写

    DELIMITER $$
CREATE    EVENT IF NOT EXISTS `event_delete_history`
ON SCHEDULE
EVERY 1 DAY STARTS TIMESTAMP(CURRENT_DATE,'01:00:00')
ON COMPLETION PRESERVE ENABLE
DO
    BEGIN
          delete from cmdb_collector_capac_value where TO_DAYS(CURDATE()) - TO_DAYS(collect_time) >7;
          delete from cmdb_collector_perf_value where TO_DAYS(CURDATE()) - TO_DAYS(collect_time) >7;
    END$$

转载于:https://my.oschina.net/taomac/blog/666341