【mysql 查询一年中的所有月份】_mysql 获取一年中所有月份

mysql 查询当前年的所有月份

数据统计中经常有这样的需求,统计今年1-12月的数据,以下博主搜寻了2种方法，希望可以帮到大家
第一种:采用union方式
select concat((select year(now())), ‘-01’) as month
union
select concat((select year(now())), ‘-02’)
union
select concat((select year(now())), ‘-03’)
union
select concat((select year(now())), ‘-04’)
union
select concat((select year(now())), ‘-05’)
union
select concat((select year(now())), ‘-06’)
union
select concat((select year(now())), ‘-07’)
union
select concat((select year(now())), ‘-08’)
union
select concat((select year(now())), ‘-09’)
union
select concat((select year(now())), ‘-10’)
union
select concat((select year(now())), ‘-11’)
union
select concat((select year(now())), ‘-12’)