查询乱码和按月查询

SET character_set_connection=utf8, character_set_results=utf8  ;

 

 

 

select
    concat('2011-',m),
    sum(
        case when DAYOFMONTH(a.date)=m
        then  a.AccessCount else 0 end
       )  ,
 a.url,b.accessSource
from
   pplive_dacweb.dac_resin_access a, pplive_dacweb.dac_resin_access_url b,
    (
        select 1 m
        union all select 2
        union all select 3
        union all select 4
        union all select 5
        union all select 6
        union all select 7
        union all select 8
        union all select 9
        union all select 10
        union all select 11
        union all select 12
    ) c
where a.url = b.url
group by  
    m,a.url
order by a.url