转：mysql按时间统计数据，没有数据的时候自动补充0

SELECT
    @cdate := DATE_ADD( @cdate, INTERVAL - 1 DAY ) `date`,
    0 AS `sum` 
FROM
    ( SELECT @cdate := DATE_ADD( CURDATE( ), INTERVAL + 1 DAY ) FROM shopping_user ) t1 
WHERE
    @cdate > ‘2017-08-03‘

SELECT
        DATE_FORMAT( ADDTIME, ‘%Y-%m-%d‘ ) AS `date`,
        COUNT( * ) AS ‘sum‘ 
    FROM
        `shopping_hibitRecord` 
    WHERE
        shopping_hibitRecord.`ADDTIME` >= ‘2017-08-03‘ 
        AND deleteStatus = FALSE 
        AND TYPE = 0 
    GROUP BY
        DATE DESC

SELECT
    `date`,
    MAX( `sum` ) AS `sum` 
FROM
    (
    SELECT
        @cdate := DATE_ADD( @cdate, INTERVAL - 1 DAY ) `date`,
        0 AS `sum` 
    FROM
        ( SELECT @cdate := DATE_ADD( CURDATE( ), INTERVAL + 1 DAY ) FROM shopping_user ) t1 
    WHERE
        @cdate > ‘2017-08-03‘ UNION ALL
    SELECT
        DATE_FORMAT( ADDTIME, ‘%Y-%m-%d‘ ) AS `date`,
        COUNT( * ) AS ‘sum‘ 
    FROM
        `shopping_hibitRecord` 
    WHERE
        shopping_hibitRecord.`ADDTIME` >= ‘2017-08-03‘ 
        AND deleteStatus = FALSE 
        AND TYPE = 0 
    GROUP BY
        DATE DESC 
    ) _tmpAllTable 
GROUP BY
    `date` DESC