mysql定时清空某个表数据

-- 检查事件调度器状态
SET @event_scheduler_status = (SELECT @@event_scheduler);-- 如果事件调度器未启用，启用它
SET @enable_event_scheduler = IF(@event_scheduler_status = 0, 'SET GLOBAL event_scheduler = ON;', 'SELECT "Event scheduler is already enabled"');
PREPARE stmt FROM @enable_event_scheduler;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;-- 删除已存在的事件（如果存在）
DROP EVENT IF EXISTS clear_your_table;-- 创建事件，每 1 分钟清空表
DELIMITER //CREATE EVENT clear_your_table
ON SCHEDULE EVERY 1 MINUTE
DO
BEGINTRUNCATE TABLE your_table;
END //DELIMITER ;

但这里有一个问题，当navicat工具关闭，再次查 SHOW VARIABLES LIKE 'event_scheduler'; 状态又变成了OFF

应该还要去改配置（未验证）：

   [mysqld]event_scheduler=ON