CREATE TABLE EVENTS_INVOKED
(EVENT_NAME VARCHAR(20) NOT NULL,
EVENT_STARTED TIMESTAMP NOT NULL);
CREATE EVENT DIRECT
ON SCHEDULE AT NOW()
DO INSERT INTO EVENTS_INVOKED VALUES ('DIRECT', NOW())
;
SELECT *
FROM EVENTS_INVOKED
WHERE EVENT_NAME = 'DIRECT'
;
drop table EVENTS_INVOKED;