mysql计数group by_使用MySQL GROUP BY表达式计数时如何包含零

我想计算上个月每天发生的事件数量,但是当没有发现任何事件时,我还要计算零数.那可能吗？

这是我从…开始的…

SELECT COUNT(*) AS count,

DATE(usage_time_local) AS d

FROM usages

WHERE user_id=136

AND DATE(usage_time_local) >= DATE('2011-04-24')

AND DATE(usage_time_local) <= DATE('2011-05-24')

GROUP BY DATE(usage_time_local);

更新：鉴于答案,我通过初始化循环然后填写详细信息来实现代码解决方案.

$dailyCount = array();

for( $i=1; $i<=30; $i++ ) {

$day = date('Y-m-d',(time()-($i*24*60*60)));

$dailyCount[$day] = 0;

}

foreach( $statement as $row ) {

$dailyCount[$row['d']] = $row['count'];

}