mysql 任务调度实现

下面是脚本之家 jb51.cc 通过网络收集整理的代码片段。

脚本之家小编现在分享给大家，也给大家做个参考。

    CREATE EVENT [IF NOT EXISTS] event_name  
      
        ON SCHEDULE schedule  
      
        [ON COMPLETION [NOT] PRESERVE]  
      
        [ENABLE | DISABLE]  
      
        [COMMENT 'comment']  
      
        DO sql_statement;  
      
    schedule:  
      
        AT TIMESTAMP [+ INTERVAL INTERVAL]  
      
    | EVERY INTERVAL [STARTS TIMESTAMP] [ENDS TIMESTAMP]  
      
    INTERVAL:  
      
        quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |  
      
                  WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |  
      
                  DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}  

    DELIMITER $$  
      /**  
         * 重置流水号  
         *   
         * @author xuyw  
         * @email [emailprotected]  
         * @date 2014-05-06  
         */  
    -- SET GLOBAL event_scheduler = ON$$     -- required for event to execute but not create      
      
    CREATE  /*[DEFINER = { user | CURRENT_USER }]*/ EVENT `xxx`.`reset_serialNumber`  
      
    ON SCHEDULE EVERY 1 DAY STARTS '2014-05-06 23:59:59'  
         /* uncomment the example below you want to use */  
      
        -- scheduleexample 1: run once  
      
           --  AT 'YYYY-MM-DD HH:MM.SS'/CURRENT_TIMESTAMP { + INTERVAL 1 [HOUR|MONTH|WEEK|DAY|MINUTE|...] }  
      
        -- scheduleexample 2: run at intervals forever after creation  
      
           -- EVERY 1 [HOUR|MONTH|WEEK|DAY|MINUTE|...]  
      
        -- scheduleexample 3: specified start time,end time and interval for execution  
           /*EVERY 1  [HOUR|MONTH|WEEK|DAY|MINUTE|...]  
      
           STARTS CURRENT_TIMESTAMP/'YYYY-MM-DD HH:MM.SS' { + INTERVAL 1[HOUR|MONTH|WEEK|DAY|MINUTE|...] }  
      
           ENDS CURRENT_TIMESTAMP/'YYYY-MM-DD HH:MM.SS' { + INTERVAL 1 [HOUR|MONTH|WEEK|DAY|MINUTE|...] } */  
      
    /*[ON COMPLETION [NOT] PRESERVE]  
    [ENABLE | DISABLE]  
    [COMMENT 'comment']*/  
      
    DO  
        BEGIN  
            UPDATE xxx_sequence  
                       SET current_value = 0  
                       WHERE id = 1;  
        END$$  
      
    DELIMITER ;  

以上是脚本之家(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得脚本之家网站内容还不错，欢迎将脚本之家网站推荐给程序员好友。

（编辑：安卓应用网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!