MySQL Count总计按年和月 [英] MySQL Count totals by year and month

问题描述

我有一张这样的表：

id,created,action
1,'2011-01-01 04:28:21','signup'
2,'2011-01-05 04:28:21','signup'
3,'2011-02-02 04:28:21','signup'

如何选择和分组这些输出是： p>

How do I select and group these so the output is:

year,month,total
2011,1,2
2011,2,1

推荐答案

尝试这样：

SELECT DATE_FORMAT(created, '%Y') as 'year',
DATE_FORMAT(created, '%m') as 'month',
COUNT(id) as 'total'
FROM table_name
GROUP BY DATE_FORMAT(created, '%Y%m')

这篇关于MySQL Count总计按年和月的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！