MySQL timed task

See if event is turned on

Open Event_scheduler

Set global Event_scheduler = 1;

Create a stored procedure Spark.test

CREATE PROCEDURE spark.test ()  BEGIN  Update spark.userbehaviordatasource Set v1 = 3 where page like ' page2% ';  END;  

Create Event Spark.e_test

Create event if not exists spark.e_test on  schedule every second on  completion Preserve  

Execute a stored procedure every minute spark.test

Close a transaction task

Alter event spark.e_test on completion PRESERVE DISABLE;  

Turn on transactional tasks

Alter event spark.e_test on completion PRESERVE ENABLE;  

Erase stored Procedure

drop procedure Spark.test;

Inserting data

Insert into Spark.userbehaviordatasource (page, v1, v2, V3) VALUES ("Page25", 1.6, 1.3, 1)

Data to be queried

Reference: http://blog.csdn.net/tjcyjd/article/details/11481459

MySQL timed task