SELECT count(a.id) AS ‘数量‘, DAY (a.create_date) AS ‘时间‘ FROM test aWHERE MONTH (a.create_date) = MONTH (NOW()) GROUP BY DAY (a.create_date)
主要使用的DAY函数和MONTH函数，GOOUP BY 分组查询 如果查询上个月每天的数据统计量
MONTH (NOW()) -1即可
原文：https://www.cnblogs.com/cyc-ghost/p/11993282.html