select DATE_FORMAT(date_add('2021-01-01', interval row MONTH),'%Y-%m') date from
(
SELECT @row := @row + 1 as row FROM
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2,
(SELECT @row:=-1) r
) se
Mysql指定时间段内的年月日时分
于 2022-03-03 20:39:34 首次发布