select distinct DATE_FORMAT(a.create_time, '%Y年%m月') ,COUNT(*)
from blog as a
where a.user_id=4 GROUP BY DATE_FORMAT(a.create_time, '%Y年%m月')
order by a.create_time DESC
sql按月归档文章
最新推荐文章于 2021-03-27 17:42:54 发布
select distinct DATE_FORMAT(a.create_time, '%Y年%m月') ,COUNT(*)
from blog as a
where a.user_id=4 GROUP BY DATE_FORMAT(a.create_time, '%Y年%m月')
order by a.create_time DESC