当前位置：网站首页>MySQL gets the collection of each day according to the start and end date

MySQL gets the collection of each day according to the start and end date

2022-04-22 19:23:00 【Pingshan CP3】

background ：mysql I want to get every day in the range according to two dates , Return as a result set .mysql Unlike sqlserver Have digital auxiliary table spt_values（ I didn't find ...）, In this way, you can only build a table by yourself .

sql sentence ：

select @num:=@num+1,date_format(adddate(@beginDate, INTERVAL @num DAY),'%Y-%m-%d') as date from dates,(select @num:=-1) t where adddate(@beginDate, INTERVAL @num DAY) < @endDate order by date

For example, get 2019-06-01 to 2019-06-05 Set for consecutive days within the range ：