xlfm22 发表于 2018-10-7 07:17:31

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]
查看完整版本: mysql自带计划任务创建语法