Event with comments : Create « Event « SQL / MySQL






  1. SQL / MySQL
  2. Event
  3. Create

Event with comments

      


mysql>
mysql>
mysql> CREATE EVENT DIRECT_INACTIVE
    ->    ON SCHEDULE AT NOW()
    ->    ON COMPLETION PRESERVE
    ->    DISABLE
    ->    COMMENT 'This event is inactive'
    ->    DO INSERT INTO EVENTS_INVOKED
    ->       VALUES ('DIRECT_INACTIVE', 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

1.Create event at TIMESTAMP(CURDATE() + INTERVAL 1 DAY, '11:00:00')
2.Create event
3.Create an event: do insert
4.CREATE EVENT ON SCHEDULE AT NOW() + INTERVAL 3 DAY
5.Create event on several schedules
6.Create event at NOW() + INTERVAL (8 - DAYOFWEEK(NOW())) DAY
7.Create event on start ... end
8.Create event on schedule
9.Show event creation