SHOW VARIABLES LIKE 'event_scheduler';
SELECT @@event_scheduler;
SHOW processlist;
#查看事件系统表
select * from information_schema.events
where EVENT_SCHEMA='test' and EVENT_NAME='evt_test';
#删除事件
DROP EVENT IF EXISTS evt_test;
#创建事件
CREATE EVENT IF NOT EXISTS evt_test
ON SCHEDULE EVERY 10 SECOND -- 10秒执行一次
STARTS CURRENT_TIMESTAMP -- 现在开始,1分钟后结束
ENDS CURRENT_TIMESTAMP + INTERVAL 1 MINUTE
ON COMPLETION PRESERVE -- 执行完后保留事件
COMMENT '测试事件' -- 备注
DO BEGIN
CREATE TABLE IF NOT EXISTS event_sum(`id` int NOT NULL AUTO_INCREMENT COMMENT '主键', sum INT, time TIMESTAMP, PRIMARY KEY (`id`) USING BTREE);
INSERT INTO event_sum(sum, time) VALUES ((SELECT count(*) FROM test1), CURRENT_TIMESTAMP);
END;
#查看事件是否成功执行
SELECT * FROM event_sum;
mysql 创建事件,样例
最新推荐文章于 2024-04-20 03:00:00 发布
![](https://img-home.csdnimg.cn/images/20240709112858.png)