MySQL定时执行存储过程

create table tmp (
id int ,
test VARCHAR(200)
);

CREATE DEFINER=root@% PROCEDURE myproc()
begin

insert into tmp(id,test) select 1,'test' from dual;
end;

-- 创建定时计划的例子,每天定时，自动将日期加1天
CREATE EVENT t_test
ON SCHEDULE EVERY 1 DAY STARTS '2021-05-17 09:40:10'
ON COMPLETION PRESERVE
ENABLE
DO
call myproc();

select * from tmp;