ON SCHEDULE AT NOW() : Schedule « Event « SQL / MySQL

1. SQL / MySQL
2. Event
3. Schedule

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)

   
    
    
    
    
  

Related examples in the same category