mysql通过时间范围查询当月每天的数据

select
    DATE(datatime) AS Date,
    SUM(count3) AS Total3,
    COUNT(DISTINCT count1) AS Total1,
    COUNT(DISTINCT count2) AS Total2
FROM 
    你的表
WHERE 
    DATE(datatime) BETWEEN #{starttime} AND #{endtime}
GROUP BY 
    DATE(datatime)
ORDER BY 
    Date;

count1,2,3都是要查询的对应字段，

datatime为数据库内存储的时间