#选择数据库
USE SECURITY;
#查看事件调度器是否开启
SELECT @@event_scheduler;
#或
SHOW VARIABLES LIKE 'event_scheduler';
#或
SHOW PROCESSLIST;
#开启事件调度器任务(1:开启 0:关闭)
SET GLOBAL event_scheduler = 1;
#或(ON:OFF)
SET GLOBAL event_scheduler = ON;
#创建测试表
CREATE TABLE IF NOT EXISTS t_schedule (userName VARCHAR(20), timeonline TIMESTAMP);
#创建事件,一秒钟就向表中插入一条数据
CREATE EVENT IF NOT EXISTS e_t_schedule_insert
ON SCHEDULE EVERY 1 SECOND
DO INSERT INTO security.t_schedule VALUES ('OSChina.net', CURRENT_TIMESTAMP);
#查看数据
SELECT * FROM t_schedule;
#删除事件调度器任务
DROP EVENT IF EXISTS SECURITY.e_t_schedule_insert;
转载于:https://my.oschina.net/xiaomaoandhong/blog/171091