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 END2010
-> ON SCHEDULE AT '2010-12-31 11:00:00'
-> DO INSERT INTO EVENTS_INVOKED VALUES ('END2010', NOW());
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql>
mysql> drop table EVENTS_INVOKED;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
|