mysql event 每隔20秒插入一条数据

//查询是否开启事件
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')