年
SELECT COUNT(想统计的字段名) ,YEAR(时间字段) years
FROM 表名
WHERE YEAR(时间字段名) = YEAR("2022-5-16 16:38:46")
GROUP BY years
月(控制在具体某年的哪个月)
SELECT COUNT(想统计的字段名),MONTH(时间字段)`monthname`,YEAR(时间字段) years
FROM 表名
WHERE MONTH(时间字段)=MONTH("2022-04-21 17:02:12") AND
YEAR(时间字段)=YEAR("2022-04-21 17:02:12")
GROUP BY `monthname`,years
周(控制在具体某年的哪个周)
SELECT COUNT(想统计的字段名),WEEK(时间字段) weeks
FROM 表名
WHERE WEEK(时间字段)=WEEK("2022-04-21 18:56:41") AND
YEAR(时间字段)=YEAR("2022-04-21 18:56:41")
GROUP BY weeks
日
SELECT COUNT(想统计的字段名) ,DATE_FORMAT (时间字段,"%Y-%m-%d") days
FROM 表名
WHERE DATE_FORMAT (时间字段,"%Y-%m-%d")=DATE_FORMAT("2022-04-21 18:56:41","%Y-%m-%d")
GROUP BY days
注,一定要注意GROUP BY分组