Andy Niu �����ĵ�

Andy Niu

Andy Niu Help  1.0.0.0
事件调度器

变量

 事件调度器
 

详细描述

变量说明

事件调度器
1、事件调度器(Event Scheduler),和计划任务(Scheduled Task)是同一个意思,schedule 是日程安排的意思。
2、语法如下:
    mysql> help create event;
    Name: 'CREATE EVENT'
    Description:
    Syntax:
    CREATE
        [DEFINER = { user | CURRENT_USER }]
        EVENT
        [IF NOT EXISTS]
        event_name
        ON SCHEDULE schedule
        [ON COMPLETION [NOT] PRESERVE]
        [ENABLE | DISABLE | DISABLE ON SLAVE]
        [COMMENT 'comment']
        DO event_body;
    
    schedule:
        AT timestamp [+ INTERVAL interval] ...
    | EVERY interval
        [STARTS timestamp [+ INTERVAL interval] ...]
        [ENDS timestamp [+ INTERVAL interval] ...]
    
    interval:
        quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
                WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
                DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}
Copyright (c) 2015~2016, Andy Niu @All rights reserved. By Andy Niu Edit.