mysql过去12个月不存在为0_MySQL统本年12个月的数据没有则为0

select * FROM

(SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'01') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'02') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'03') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'04') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'05') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'06') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'07') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'08') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'09') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'10') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'11') as mon from  DUAL UNION ALL

SELECT CONCAT(DATE_FORMAT(NOW(),'%Y'),'12') as mon from  DUAL )a

LEFT JOIN

(SELECT

DATE_FORMAT(stat_time,'%Y%m') smon,

s.*,

ifnull(condition,0)

FROM

tables   s

GROUP BY

DATE_FORMAT(stat_time,'%Y%m')) b

on a.mon = b.smon

tables  要统计的表

stat_time   tables 表中要统计时间

查询条件 ifnull 判断