mysql event and procedure 一例：

最新推荐文章于 2022-09-20 14:00:00 发布

Jack_Skipper

最新推荐文章于 2022-09-20 14:00:00 发布

阅读量956

点赞数

分类专栏：数据库与jdbc等相关操作文章标签： mysql date insert

本文链接：https://blog.csdn.net/flfna/article/details/6569801

版权

数据库与jdbc等相关操作专栏收录该内容

23 篇文章 0 订阅

订阅专栏

CREATE PROCEDURE busytime_pro()
BEGIN

DECLARE busytime_start TIME;
DECLARE busytime_end TIME;
DECLARE busytime_peoplecount Integer;

SET busytime_start = '08:00:00';
SET busytime_end = '18:00:00';
SET busytime_peoplecount = 6;

WHILE TIMEDIFF(busytime_end,busytime_start)>=0
DO
INSERT into busytime(busytime_start, busytime_peoplecount, busytime_style, busytime_date )
    values(busytime_start, busytime_peoplecount , '日常保养' ,current_date());

INSERT into busytime(busytime_start, busytime_peoplecount, busytime_style, busytime_date )
    values(busytime_start, busytime_peoplecount , '维修服务' ,current_date());

INSERT into busytime(busytime_start, busytime_peoplecount, busytime_style, busytime_date )
    values(busytime_start, busytime_peoplecount , '新车试驾' ,current_date());

INSERT into busytime(busytime_start, busytime_peoplecount, busytime_style, busytime_date )
    values(busytime_start, busytime_peoplecount , '以旧换新' ,current_date());

SET busytime_start = ADDTIME(busytime_start, '0:30:0');
END WHILE;

END;

CREATE EVENT busytime_event_D
ON SCHEDULE
EVERY 1 day STARTS TIMESTAMP '2009-12-18 23:00:00'
ON COMPLETION PRESERVE
DO
call busytime_pro();