DROP EVENT IF EXISTS delete_old_data_event;
CREATE EVENT delete_old_data_event
ON SCHEDULE EVERY 2 MINUTE
STARTS '2023-08-01 00:00:00'
DO
DELETE FROM TEST_log WHERE IN_TIME <= DATE_SUB(NOW(), INTERVAL 9 MONTH);
创建mysql 设置定时任务自动删除对应数据
最新推荐文章于 2024-04-12 15:22:49 发布