Events in MySQL (Scheduled tasks)

I. What is an event

A set of SQL sets, used to perform timed tasks, much like a trigger, is executed passively, because time is triggered and the trigger is triggered by an event (incremental deletion).

Second, the opening event

To see if it is turned on:

 like ' Event_scheduler ';

If off is displayed, enter the following statement to open:

Set = off;

Iii. Custom Simple Events

To create a new user table:

-- ------------------------------Table structure for ' user '-- ----------------------------DROP TABLE IF EXISTS`User`;CREATE TABLE`User' (' ID 'bigint( -) not NULLauto_increment, ' name 'varchar( $) not NULL, ' address 'varchar( -) not NULL, ' Addtime 'datetime  not NULL,  PRIMARY KEY(' id ')) ENGINE=InnoDBDEFAULTCHARSET=UTF8;

Create a new time and insert a single piece of data every minute:

Parameter description:

Definer: creator;

On completion [NOT] PRESERVE: indicates that when the time does not occur, delete the event (note the event at a specific time, if the parameter is set, the event will be deleted when the execution is complete, and you can set it to on if you do not want to delete it). Completion PRESERVE);

ENABLE: indicates that the system will execute this event;

-- ------------------------------Event structure for ' Event_minute '-- ----------------------------DROPEVENTIF EXISTS' Event_minute ';D elimiter;;CREATEDefiner=' Root ' @ ' localhost ' EVENT ' event_minute ' onSCHEDULE every1MINUTE starts'2016-01-17 14:49:43'  onCompletion notPRESERVE ENABLE Do

BEGIN    INSERT  into USER(Name, Address,addtime)VALUES('test1','test1', now ()); INSERT  into USER(Name, Address,addtime)VALUES('test2','test2', now ());END;;D Elimiter;

Create a new event, specific time 2016-01-17 15:30:00 insert a piece of data

-- ------------------------------Event structure for ' event_at '-- ----------------------------DROPEVENTIF EXISTS' event_at ';D elimiter;;CREATEDefiner=' Root ' @ ' localhost ' EVENT ' event_at ' onSCHEDULE at'2016-01-17 15:30:00'  onCompletion notPRESERVE ENABLE Do

BEGIN    INSERT  into USER(Name, Address,addtime)VALUES(' at',' at', now ());END;;D Elimiter;

To view the results, the results are correct:

Events in MySQL (Scheduled tasks)