mySQL中有event如下面创建一个每日执行的一个计划。 但建议还是用操作系统的计划任务或crontab来实现比较方便可靠 DELIMITER |CREATE EVENT e_daily ON SCHEDULE EVERY 1 DAY COMMENT 'Saves total number of sessions then clears the table each day.' DO BEGIN INSERT INTO site_activity.totals (when, total) SELECT CURRENT_TIMESTAMP, COUNT(*) FROM site_activity.sessions; DELETE FROM site_activity.sessions; END |DELIMITER ;
DELIMITER |CREATE EVENT e_daily
ON SCHEDULE
EVERY 1 DAY
COMMENT 'Saves total number of sessions then clears the table each day.'
DO
BEGIN
INSERT INTO site_activity.totals (when, total)
SELECT CURRENT_TIMESTAMP, COUNT(*)
FROM site_activity.sessions;
DELETE FROM site_activity.sessions;
END |DELIMITER ;
如果我没记错的话是从5.1版本才有的Event Scheduler
如果是之前版本,还是要用系统的crontab