mysql

mysql按月查询数据，本方法，有效
select sum(case month(u.createTime) when '1' then 1 else 0 end) as one, sum(case month(u.createTime) when '2' then 1 else 0 end) as two, sum(case month(u.createTime) when '3' then 1 else 0 end) as three, sum(case month(u.createTime) when '4' then 1 else 0 end) as four, sum(case month(u.createTime) when '5' then 1 else 0 end) as five, sum(case month(u.createTime) when '6' then 1 else 0 end) as six, sum(case month(u.createTime) when '7' then 1 else 0 end) as seven, sum(case month(u.createTime) when '8' then 1 else 0 end) as eight, sum(case month(u.createTime) when '9' then 1 else 0 end) as nine, sum(case month(u.createTime) when '10' then 1 else 0 end) as ten, sum(case month(u.createTime) when '11' then 1 else 0 end) as eleven, sum(case month(u.createTime) when '12' then 1 else 0 end) as twelve fromuseru where year(u.createTime)=#{year} group by u.createTime