//php mysql 怎么实现博客按月归档 
SELECT FROM_UNIXTIME(addtime,  '%Y-%m') AS datestime, COUNT( * ) AS cnt
FROM  admin_news
GROUP BY datestime order by FROM_UNIXTIME(addtime,  '%Y-%m') desc 
LIMIT 0 , 30

datestime cnt
2022-02   27
2019-10   6

//select FROM_UNIXTIME(addtime, '%Y-%m') as t  from admin_news where t = '2022-02' 
//select *  from admin_news where FROM_UNIXTIME(addtime, '%Y-%m')  = '2022-02' 

查询 _addtime 在 2022 年 02 月份的数据;
select id,title,FROM_UNIXTIME(addtime, '%Y-%m') as creattime from admin_news where FROM_UNIXTIME(addtime, '%Y-%m')  = '2022-02' 

select id,title,FROM_UNIXTIME(addtime, '%Y-%m') as creattime from admin_news where FROM_UNIXTIME(addtime, '%Y-%m')  = '2019-10' 

mysql文章归档代码结束

发表评论 已发布 0

还可以输入 800 个字
 
 
打印