mysql自带计划任务创建语法
SET GLOBAL event_scheduler = 1;delimiter //
drop event if exists test //
CREATE EVENT test
ON SCHEDULE
EVERY 5 SECOND
starts '2017-12-08 00:00:00'
DO
BEGIN
insert into erp_commod_receive set receive_order=1;
END //
delimiter ;
页:
[1]