mysql根据月份查询无数据的月份默认为0

做图表统计免不了根据月份查询，那么怎样写sql语句呢？可以用union all 解决这个问题。

结果如下所示

select m.id name, IFNULL(b,0) value from
(
  select 1 as id union select 2 union select 3 union select 4 union select 5 union select 6
  union select 7 union select 8 union select 9 union select 10 union select 11 union select 12
) m
left join 
(select month(com_date) a,count(title) b from complaint GROUP BY month(com_date)) n 
on m.id = n.a