mysql 生成一个临时日历表

begin
declare indexdate DATE;
set indexdate = DATE('2016-01-01');
while indexdate <= DATE('2020-12-31') do
insert into temp_date(create_date) values(indexdate);
set indexdate = ADDDATE(indexdate,1) ;
end while;
end