云数据库 GAUSSDB-CREATE EVENT:语法格式

时间：2024-11-02 18:45:38

云数据库 GAUSSDB

语法格式

CREATE
    [DEFINER = user]
EVENT
    [IF NOT EXISTS]
    event_name
    ON SCHEDULE schedule
    [ON COMPLETION [NOT] PRESERVE]
    [ENABLE | DISABLE | DISABLE ON SLAVE]
    [COMMENT 'string']
    DO event_body;

schedule：

    
         { 
    AT timestamp [+ INTERVAL interval] ...
  | EVERY interval
    [STARTS timestamp [+ INTERVAL interval] ...]
    [ENDS timestamp [+ INTERVAL interval] ...]
}

interval：

quantity {YEAR | MONTH | DAY | HOUR | MINUTE | SECOND |
          YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
          DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | 
          MINUTE_SECOND}

上一篇：云数据库 GAUSSDB-CREATE EVENT:注意事项

下一篇：云数据库 GAUSSDB-CREATE EVENT:注意事项