Alter event : Alter « Event « SQL / MySQL

1. SQL / MySQL
2. Event
3. Alter

Alter event

    

CREATE TABLE EVENTS_INVOKED
      (EVENT_NAME      VARCHAR(20) NOT NULL,
       EVENT_STARTED   TIMESTAMP NOT NULL);

ALTER EVENT STARTMONTH
   ON SCHEDULE EVERY 1 MONTH
      STARTS CURDATE() + INTERVAL 1 MONTH -
             INTERVAL (DAYOFMONTH(CURDATE()) - 1) DAY
      ENDS   TIMESTAMP('2025-12-31');

drop table EVENTS_INVOKED;
mysql>
mysql>

   
    
    
    
  

Related examples in the same category