2020-02-16 标签:php,文章,按日,sql,归档,语句,实现,代码,如下,select,unixtime,pubtime,y,m,count,cnt,articles,group,d

实现代码如下： select FROM_UNIXTIME(pubtime, '%Y-%m') as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, '%Y-%m')PHP文章按日期（日）SQL归档 实现代码