PHP文章按日期（月日）SQL归档PHP文章按日期（月）SQL归档实现语句，需要的朋友可以参考下

复制代码 代码如下: select FROM_UNIXTIME(pubtime, ‘%Y-%m’) as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, ‘%Y-%m’) PHP文章按日期（日）SQL归档 复制代码 代码如下: select FROM_UNIXTIME(pubtime, ‘%Y-%m-%d’) as pubtime, count(*) as cnt from articles grou