Create event on start ... end : Create « Event « SQL / MySQL

1. SQL / MySQL
2. Event
3. Create

Create event on start ... end

      
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> CREATE EVENT SIXTIMES
    ->    ON SCHEDULE EVERY 1 MINUTE
    ->       STARTS TIMESTAMP(CURDATE() + INTERVAL 1 DAY,'12:00:00')
    ->       ENDS   TIMESTAMP(CURDATE() + INTERVAL 1 DAY,'12:00:00')
    ->              + INTERVAL 5 MINUTE
    ->    DO INSERT INTO EVENTS_INVOKED
    ->       VALUES ('SIXTIMES', NOW());
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table EVENTS_INVOKED;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>

   
    
    
    
    
    
  

Related examples in the same category