每天定时执行存储过程

每天定时执行存储过程

1.创建存储过程 

CREATE  PROCEDURE `update_cloud_componentrepairrecorTime`()

BEGIN

update cloud_componentrepairrecord

set

 StartTime = now(),

 Endtime =  date_add( now() , INTERVAL   datediff(Starttime ,Endtime) day )

 where endtime<=now();

END 

 

 2.定时执行

CREATE EVENT event_update_cloud_componentrepairrecorTime

ON SCHEDULE EVERY 1 DAY STARTS '2018-06-01 00:00:00'

ON COMPLETION PRESERVE

ENABLE

DO call update_cloud_componentrepairrecorTime();

posted on 2018-06-02 09:44  笨小孩做开发 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/dullbaby/p/9124541.html