如果要每10秒执行以下语句: [sql] view plain copy INSERT INTO `testTable` (`name`) VALUES ('test'); 可以给mysql建个定时任务,具体方法如下: [sql] view plain copy delimiter // /* 设定语句终结符为 //,因存储过程语句用;结束 */ 一、查看event是否开启 [sql] view plain copy show variables like '%sche%'; 开启event_scheduler [sql] view plain copy set global event_scheduler =1; 二、创建存储过程testTableInsert [sql] view plain copy CREATE PROCEDURE testTableInsert() BEGIN INSERT INTO `testTable` (`name`) VALUES ('test'); END; 三、创建evente_testTableInsert [sql] view plain copy create event if not exists e_testTableInsert on schedule every 30 second on completion preserve //执行结束DISABLE 不删除 do call testTableInsert(); 每隔10秒将执行存储过程testTableInsert 关闭事件任务 [sql] view plain copy alter event e_testTableInsert ON COMPLETION PRESERVE DISABLE; 开户事件任务 [sql] view plain copy alter event e_testTableInsert ON COMPLETION PRESERVE ENABLE;