//查询是否开启事件
show VARIABLES LIKE ‘event_scheduler’
//打开事件
SET GLOBAL event_scheduler=1
//查询event
show EVENTS
//删除event
drop event myevent
CREATE
EVENT myevent
ON SCHEDULE
EVERY 20 second
DO
INSERT INTO lx_cpuinfo_c (IpAddress
,CpuUsage
,CpuIdle
,CpuName
,CpuCores
,Cpus
,CpuMhz
,Occurrtime
) VALUES (‘1’, ‘2’,‘3’,‘4’,‘5’,‘6’,‘7’,‘8’)