Mega Code Archive
ON SCHEDULE EVERY 1 YEAR
mysql>
mysql> CREATE TABLE EVENTS_INVOKED
-> (EVENT_NAME VARCHAR(20) NOT NULL,
-> EVENT_STARTED TIMESTAMP NOT NULL);
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql> CREATE EVENT END_OF_YEAR
-> ON SCHEDULE EVERY 1 YEAR
-> STARTS ((NOW() - INTERVAL (DAYOFYEAR(NOW()) - 1) DAY)
-> + INTERVAL 1 YEAR)
-> - INTERVAL 1 DAY
-> ENDS '2025-12-31'
-> DO INSERT INTO EVENTS_INVOKED VALUES ('END_OF_YEAR', NOW());
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> drop table EVENTS_INVOKED;
Query OK, 0 rows affected (0.00 sec)
mysql>