mysql查询没有返回0_MySQL查询返回数字'零'，如果没有结果

When selecting a DATE and that date does not exist in my table it currently will return an empty result set. How can I be able to return the number zero for those empty result sets instead?:

SELECT SUM(TOTAL), SUM(5STAR), STORE, DATE

FROM `table` WHERE DATE >= '2012-02-24' GROUP BY TOTAL

MySQL returned an empty result set (i.e. zero rows)

I want to instead return the results of the SUM(TOTAL) and SUM(5STAR) (if zero rows) as the number zero (0).

FULL TABLE STRUCTURE:

ID = Primary

DATE = UNIQUE (date)

STORE

5STAR

4STAR

3STAR

2STAR

1STAR

TOTAL

FROM = UNIQUE

解决方案

I think it would be easier to handle the empty result set on the PHP side (count the returned rows). If you want to handle it in the database, you should create a stored procedure.

DELIMITER $$

CREATE PROCEDURE `mc`.`new_routine` (IN DT DATETIME)

BEGIN

IF EXISTS (SELECT 1 FROM `table` WHERE DATE >= @DT)

THEN

SELECT SUM(TOTAL) AS SumTotal, SUM(5STAR) AS Sum5Star, STORE, `DATE`

FROM `table`

WHERE DATE >= @DT

GROUP BY TOTAL;

ELSE

SELECT 0 AS SumTotal, 0 AS Sum5Star, NULL AS STORE, NULL AS `DATE`;

END IF;

END