我需要帮助创建一个查询,该查询将显示月份的名称,即使该月没有任何活动。MySQL显示所有月份
我只从一个表中获取我的数据。
| apptID | apptType | Date |
|----------------------------------------|
| 1 | Implementation | 2017-03-19 |
| 2 | Meeting | 2017-03-01 |
| 3 | Meeting | 2017-04-04 |
等等
我能够创建一个查询,显示约会的总数(按类型,每月),但它并不表明没有活动的月份。
这是我的代码:
SELECT DATE_FORMAT(appointment.date, '%M') AS 'Month',
SUM(CASE WHEN description = 'Meeting' THEN 1 ELSE 0 END) AS 'Meeting',
SUM(CASE WHEN description = 'Consultation' THEN 1 ELSE 0 END) AS 'Consultation',
SUM(CASE WHEN description = 'Implementation' THEN 1 ELSE 0 END) AS 'Implementation',
SUM(CASE WHEN description = 'Follow-up' THEN 1 ELSE 0 END) AS 'Follow-up'
FROM appointment GROUP BY MONTH(date)
我想保持这种相同的格式(记录是由月)
谢谢
2017-03-19
afrocode