@MySQL创建存储过程加定时任务

show variables like ‘%event_sche%’; 查看定时策略是否开启

set global event_scheduler=1; 开启定时策略

//创建存储过程
use iot_greenhouse;
delimiter //
create procedure test_procedure ()
begin
insert into wechat.user(account) select row_id from tea_iot.iot_greenhouse ORDER BY tea_iot.iot_greenhouse.created_date LIMIT 1
end//
delimiter ;
//创建定时任务
create event run_event
on schedule every 5 minute
on completion preserve disable
do call test_procedure ( test_procedure ());

SELECT event_name,event_definition,interval_value,interval_field,status
FROM information_schema.EVENTS;

//开启定时任务
alter event run_event on completion preserve enable;