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
END //
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 ;
本文转自 Lee_吉 51CTO博客，原文链接:http://blog.51cto.com/12173069/2048572
