「MySQL」- Stored Objects

Event Scheduler

文档 | https://dev.mysql.com/doc/refman/8.4/en/event-scheduler.html

示例：

CREATE EVENT e_hourly
    ON SCHEDULE
      EVERY 1 HOUR
    COMMENT 'Clears out sessions table each hour.'
    DO
      DELETE FROM site_activity.sessions;