mysql+group+by+默认0_带有“默认值”的SQL GROUP BY

我正在尝试使用GROUP BY子句创建SELECT语句,该子句应返回“默认值”.

想象一下以下简单的MySQL表：

CREATE TABLE `tracker` (

`id` INTEGER PRIMARY KEY auto_increment,`date` DATETIME NOT NULL,`customer_id` INTEGER NOT NULL

);

该表只包含一条记录：

INSERT INTO `tracker` (`date`,`customer_id`) VALUES('2010-05-03',1);

在病房之后,我正在执行以下SQL查询：

SELECT DATE(`date`),COUNT(customer_id) FROM tracker

WHERE DATE(`date`) >= '2010-05-01' AND DATE(`date`) <= '2010-05-05'

GROUP BY DATE(`date`) ORDER BY DATE(`date`);

并获得预期的结果集：

+----+---------------------+-------------+

| id | date | customer_id |

+----+---------------------+-------------+

| 1 | 2010-05-10 00:00:00 | 1 |

+----+---------