Create event : Create « Event « SQL / MySQL

1.	Aggregate Functions
2.	Backup Load
3.	Command MySQL
4.	Cursor
5.	Data Type
6.	Database
7.	Date Time
8.	Engine
9.	Event
10.	Flow Control
11.	FullText Search
12.	Function
13.	Geometric
14.	I18N
15.	Insert Delete Update
16.	Join
17.	Key
18.	Math
19.	Procedure Function
20.	Regular Expression
21.	Select Clause
22.	String
23.	Table Index
24.	Transaction
25.	Trigger
26.	User Permission
27.	View
28.	Where Clause
29.	XML

SQL / MySQL » Event » Create

Create event

      





CREATE TABLE EVENTS_INVOKED

      (EVENT_NAME      VARCHAR(20) NOT NULL,

       EVENT_STARTED   TIMESTAMP NOT NULL);





CREATE EVENT DIRECT

   ON SCHEDULE AT NOW()

   DO INSERT INTO EVENTS_INVOKED VALUES ('DIRECT', NOW())

;



SELECT   *

FROM     EVENTS_INVOKED

WHERE    EVENT_NAME = 'DIRECT'

;



drop table EVENTS_INVOKED;

Related examples in the same category

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

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.