mysql 按月统计默认0 获取一年12个月
月份获取
SELECT
DATE_FORMAT( @date, '%Y-%m' ) date,
MONTH ( @date ) AS MONTH,
@date := date_add( @date, INTERVAL 1 MONTH )
FROM
(
SELECT
@date := ( SELECT date_sub( curdate( ), INTERVAL dayofyear( curdate( ) ) - 1 DAY ) )
FROM
employee
LIMIT 12
) AS a