mysql 按照月份对数据进行分组或者是排序

笔记 / 2013-11-27

select  DATE_FORMAT(releaseTime,'%Y-%m'),count(DATE_FORMAT(releaseTime,'%Y-%m')) from logsinfo group by DATE_FORMAT(releaseTime,'%Y-%m') order by logsinfoid desc

使用mysql 自己提供的 DATE_FORMAT 可以进行的排序。

Reproduced please indicate the author and the source, and error a link to this page.
text link: /149.html