CREATE EVENT e_api_log_daily
ON SCHEDULE EVERY 1 DAY STARTS ‘2019-12-29 01:00:00’
ON COMPLETION PRESERVE ENABLE
DO
call api_log_statistics(DATE_ADD(CURDATE(), INTERVAL -1 DAY),@a);
Mysql创建每天执行存储过程的事件
最新推荐文章于 2023-10-27 10:10:27 发布
CREATE EVENT e_api_log_daily
ON SCHEDULE EVERY 1 DAY STARTS ‘2019-12-29 01:00:00’
ON COMPLETION PRESERVE ENABLE
DO
call api_log_statistics(DATE_ADD(CURDATE(), INTERVAL -1 DAY),@a);