mysql 创建事件

1、查看所有事件

show events

2、查看是否开启事件

SHOW VARIABLES LIKE 'event_scheduler';

3、查看事件详情

SELECT * FROM information_schema.events limit 1;

4、创建事件

CREATE EVENT information_0 ON SCHEDULE EVERY 1 DAY STARTS DATE_ADD( DATE_ADD( CURDATE(), INTERVAL 1 DAY ), INTERVAL 1 HOUR ) DO
DELETE FROM information_0 WHERE release_time < DATE_SUB( CURRENT_TIMESTAMP, INTERVAL 30 DAY );


CREATE EVENT test ON SCHEDULE EVERY 1 DAY STARTS CURRENT_DATE + INTERVAL 1 DAY + INTERVAL 2 HOUR ON COMPLETION PRESERVE 
DO delete from  monitor_domestic_data_0 where monitor_id in (select monitor_id from monitor_scheme) and create_time< DATE_SUB( CURRENT_TIMESTAMP, INTERVAL 5 MONTH );

5、删除语句

DROP EVENT [IF EXISTS] event_name;