mysql 统计一段时间之内每天记录数量

select
DATE_FORMAT(creatTime,'%Y-%m-%d') as time,COUNT(id) as 数量
from 表名
WHERE
<![CDATA[ DATE_FORMAT(creatTime,'%Y-%m-%d') >= #{startTime} ]]>
and
<![CDATA[ DATE_FORMAT(creatTime,'%Y-%m-%d')  <= #{endTime} ]]>
GROUP BY time
ORDER BY time

备注： creatTime 是表中日期记录字段。

            startTime是开始时间。

           endTime 是结束时间。

示例

select
DATE_FORMAT(creatTime,'%Y-%m-%d') as time,COUNT(id) as 数量
from zcts_policy
WHERE
 DATE_FORMAT(creatTime,'%Y-%m-%d') >= '2019-03-01' 
and
 DATE_FORMAT(creatTime,'%Y-%m-%d')  <= '2019-11-05' 
GROUP BY time
ORDER BY time