ON SCHEDULE AT NOW()
mysql> mysql> CREATE TABLE EVENTS_INVOKED -> (EVENT_NAME VARCHAR(20) NOT NULL, -> EVENT_STARTED TIMESTAMP NOT NULL); ERROR 1050 (42S01): Table 'events_invoked' already exists mysql> mysql> mysql> mysql> CREATE EVENT DIRECT -> ON SCHEDULE AT NOW() -> ON COMPLETION PRESERVE -> DO INSERT INTO EVENTS_INVOKED VALUES ('DIRECT', NOW()); Query OK, 0 rows affected (0.00 sec) mysql> mysql> drop table EVENTS_INVOKED; Query OK, 0 rows affected (0.00 sec)
1. | Event schedule start with case clause | ||
2. | Event schedule every week | ||
3. | ON COMPLETION PRESERVE | ||
4. | ON SCHEDULE EVERY 1 MONTH | ||
5. | ON SCHEDULE EVERY 3 MONTH |