随手记下数据库定时任务

DROP EVENT IF EXISTS e_delete_eventsinfo;
CREATE EVENT e_delete_eventsinfo
ON SCHEDULE
EVERY 1 DAY STARTS '2018-09-20 14:00:00'
DO
DELETE FROM`ecs_events_info` WHERE grade='0';

 

sql事件命名为 e_delete_eventsinfo

每天执行一次,起始时间为'2018-09-20 14:00:00'

要执行的sql语句为DELETE FROM`ecs_events_info` WHERE grade='0';

 

查看数据库的EVENTS状态和开启EVENTS

SHOW VARIABLES LIKE 'event_scheduler';
SET GLOBAL event_scheduler = ON;