MySQL定时执行存储过程

1、创建存储过程

CREATE DEFINER=`root`@`%` PROCEDURE `synData`()
BEGIN
	 drop table if exists user;
	 create table user select * from rych.user;
END

2、创建定时任务事件

CREATE DEFINER=`root`@`localhost` EVENT `loop_syn` 
ON SCHEDULE EVERY 20 MINUTE STARTS '2022-03-18 03:05:00' 
ON COMPLETION NOT PRESERVE ENABLE 
DO CALL `synData`

3、开启定时器

set GLOBAL event_scheduler = 1; 

4、开启/暂停事件

ALTER EVENT loop_syn ENABLE;