mysql中查询当月每一天的数据量没有的补零

select aa.DAY,(select count(*) from notice t where substr( t.create_time, 1, 10 )=aa.DAY
) as ss
from (SELECT
        date_add(DATE_ADD(curdate(), INTERVAL - DAY(curdate()) + 2 DAY),
        INTERVAL (cast( help_topic_id AS signed INTEGER ) - 1 ) DAY 
        ) DAY 
    FROM
        mysql.help_topic 
    WHERE
        help_topic_id < DAY ( last_day( curdate( ) ) ) 
    ORDER BY
        help_topic_id) aa
版权声明：本文为xww_inmylife原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。