查看事件调度器是否开启
SELECT @@event_scheduler;
SHOW VARIABLES LIKE 'event%';
开启定时器
set GLOBAL event_scheduler = 1;
SET GLOBAL event_scheduler = ON;
设计定时器
DROP EVENT IF EXISTS DS;
CREATE EVENT DS
ON SCHEDULE EVERY 10 SECOND
DO
INSERT INTO ecs_ceshi (time,money) SELECT CURRENT_TIMESTAMP,SUM(user_money) FROM ecs_users;
END;