CREATE EVENT - Scheduled Task İçindir

Giriş

Açıklaması şöyle

Starting from MySQL 9.0.0, the following Event syntax is available:

CREATE EVENT (create event)

ALTER EVENT (modify event)

DROP EVENT (delete event)

EVENT statements do not support the use of placeholder parameters (?).

CREATE EVENT

İmzası şöyle

CREATE EVENT event_name
    ON SCHEDULE AT or EVERY + specified interval
    DO SQL_statement

Örnek

Şöyle yaparız

CREATE EVENT myevent
    ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
    DO
      UPDATE myschema.mytable SET mycol = mycol + 1;