先看下效果
输入参数20181010 20181101
结果图
实现步骤
上代码
CREATE DEFINER=`root`@`localhost` PROCEDURE `date_dowhile`(i_begindate VARCHAR(20), i_enddate VARCHAR(20))
BEGIN
#Routine body goes here...
declare v_firstday date;
declare v_lastday date;
select date_format(i_begindate,'%Y-%m-%d'),date_format(i_enddate,'%Y-%m-%d') into v_firstday,v_lastday;
DROP temporary TABLE IF EXISTS tmp_t;
create temporary table if not exists tmp_t(-- 创建临时表保存查询的结果集中的需要的数据
DATE date
);
WHILE v_firstday <= v_lastday DO
INSERT IGNORE INTO tmp_t(DATE) VALUE (v_firstday) ;
SET v_firstday = v_firstday + IN