MYSQL按天统计文档的语句_dede日期归类插件
SELECT date( from_unixtime( pubdate ) ) AS date, count( * ) AS num FROM dede_archives GROUP BY date( from_unixtime( pubdate ) )
做dedecms日期归类插件不可少的语句
发布时间: 2012-11-10 10:48:51 作者: rapoo
MYSQL按天统计文档的语句_dede日期归类插件
SELECT date( from_unixtime( pubdate ) ) AS date, count( * ) AS num FROM dede_archives GROUP BY date( from_unixtime( pubdate ) )