创建定时事件:设置5秒往test表添加一次数据,添加的数值为一个设置的随机数;
CREATE EVENT IF NOT EXISTS event_test
ON SCHEDULE EVERY 5 SECOND ON COMPLETION PRESERVE
DO INSERT INTO test (NAME,
VALUE,
CREATE_TIME
)
VALUES
('temper',
TRUNCATE((20 + RAND() * 10),2) ,
DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s'))
-- 开启事件
ALTER EVENT event_test ON
COMPLETION PRESERVE ENABLE;
-- 关闭事件
ALTER EVENT event_test ON
COMPLETION PRESERVE DISABLE;