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;
文档 | 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;