SELECT DATE(时间字段) as registertime,COUNT(1) as newRegistrationNum
FROM 表名
WHERE DATE_SUB(CURDATE(),INTERVAL 11 MONTH)<=DATE(时间字段)
GROUP BY YEAR(registertime),MONTH(registertime) ORDER BY registertime
mysql 查询每年每个月的数据
最新推荐文章于 2024-02-20 14:40:42 发布