MySql按周,按月,按日分组统计数据
摘要:
select DATE_FORMAT(date,'%Y%u') weeks,count(id) count from table group by weeks; select DATE_FORMAT(date,'%Y%m%d') days,count(id) count from table gro 阅读全文
posted @ 2017-02-12 14:20 会学习的猪 阅读(4075) 评论(0) 推荐(0) 编辑