DROP PROCEDURE IF EXISTS `insertManyDate`; CREATE DEFINER = PROCEDURE `insertManyDate`(IN `beginDate` date,IN `endDate` date) COMMENT '根据输入的起止日期,循环插入每天的时间' BEGIN DECLARE nowdate date DEFAULT NOW(); DECLARE endtmp date DEFAULT NOW(); set nowdate = DATE_FORMAT(…