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

时间：2024-11-13 14:46:59

云数据库 GAUSSDB A

语法格式

ALTER
    [DEFINER = user]    
EVENT event_name
    [ON SCHEDULE schedule]
    [ON COMPLETION [NOT] PRESERVE]
    [RENAME TO new_event_name]
    [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 TO MONTH | DAY TO HOUR | DAY TO MINUTE |
          DAY TO SECOND | HOUR TO MINUTE | HOUR TO SECOND | 
          MINUTE TO SECOND}

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

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