#选择数据库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 SECONDDO INSERT INTO security.t_schedule VALUES ('OSChina.net', CURRENT_TIMESTAMP);#查看数据SELECT * FROM t_schedule;#删除事件调度器任务DROP EVENT IF EXISTS SECURITY.e_t_schedule_insert;