!--NEWSZW_HZH_BEGIN--
复制代码 代码以下:
select FROM_UNIXTIME(pubtime, "%Y-%m") as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, "%Y-%m") select FROM_UNI
阅读背景：
PHP文章按日期(月日)SQL归档语句
来源：互联网
select FROM_UNIXTIME(pubtime, "%Y-%m") as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, "%Y-%m") select FROM_UNI
分享到：
