查询乱码和按月查询

iteye_19528

于 2012-01-04 15:29:24 发布

阅读量145

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/iteye_19528/article/details/82241683

版权

数据库专栏收录该内容

25 篇文章 0 订阅

订阅专栏

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