mysql 查询当月数据 mysql查询每月数据

查询每天的数据：

 

SELECT
 
COUNT(1) AS countNumber,
 
DATE_FORMAT(createTime,'%Y-%m-%d') AS dateTime
 
FROM
 
testTable
 
GROUP BY DATE_FORMAT(createTime,'%Y-%m-%d')

 

查询每周的数据：

 

SELECT

COUNT(1) AS countNumber,


WEEK(createTime) as dateTime

FROM

testTable


GROUP BY WEEK(createTime)

 

查询每月的数据：

 

SELECT

COUNT(1) AS countNumber,

MONTH(createTime) as dateTime

FROM


testTable


GROUP BY MONTH(createTime)

 

查询每年的数据：

 

 

SELECT

COUNT(1) AS countNumber,

YEAR(createTime) as dateTime

FROM


testTable


GROUP BY YEAR(createTime)

 

 

本博客仅为个人记录，作为日记式博客。如有错误不足请指出，感谢。