2023-04-24 11:07:28
•
21793
mysql文章归档
//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文章归档代码结束