Create event : Create « Event « SQL / MySQL

1. SQL / MySQL
2. Event
3. Create

Create event

      


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;

   
    
    
    
    
    
  

Related examples in the same category