mysql如何按月份分组查询-木庄网络博客

2022-02-13 15:29:02 PHP中文网数据库百度已收录

本文摘自PHP中文网，作者coldplay.xixi，侵删。

mysql按月份分组查询的方法：根据format字符串格式化date值，语法为【DATE_FORMAT(date,format)】，其中【%M 】为月的名字。

mysql按月份分组查询的方法：

1 2	`select DATE_FORMAT(createtime,'%Y-%m'),count() from test where user =8 group by DATE_FORMAT(createtime,'%Y-%m');//按月统计数据` `select DATE_FORMAT(createtime,'%Y-%m-%d'),count() from test where user =8 group by DATE_FORMAT(createtime,'%Y-%m-%d');//按天统计数据`

+---------------------------------+----------+
| DATE_FORMAT(createtime,'%Y-%m') | count(*) |
+---------------------------------+----------+
| 2015-05                         |        1 |
| 2015-06                         |        1 |
| 2015-07                         |        5 |
| 2015-08                         |        1 |
+---------------------------------+----------+
4 rows in set