set global event_scheduler =1; // 开启定时任务
SHOW VARIABLES
LIKE
'%event_sche%'
; // 查看是不是开启
// 创建定时任务
DELIMITER $$
CREATE
ON SCHEDULE EVERY 1 MINUTE
ON COMPLETION PRESERVE
DO
BEGIN
CALL refreshGoods();
END$$
DELIMITER ;
set global event_scheduler =1; // 开启定时任务
SHOW VARIABLES
LIKE
'%event_sche%'
; // 查看是不是开启
// 创建定时任务
DELIMITER $$
CREATE
ON SCHEDULE EVERY 1 MINUTE
ON COMPLETION PRESERVE
DO
BEGIN
CALL refreshGoods();
END$$
DELIMITER ;