- 链接地址:https://blog.csdn.net/csdncjh/article/details/120038143
- 链接标题:MySQL统计数据,没有记录的自动补充0_ifnull(count(sd.id),0)-CSDN博客
- 所属网站:blog.csdn.net
- 被收藏次数:6737
文章浏览阅读1k次。按周select DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tc_case group by weeks;按月select DATE_FORMAT(create_time,'%Y%m') months,count(caseid) count from tc_case group by months;按天select DATE_FORMAT(create_time,'%Y%m%d') days,count._ifnull(count(sd.id),0)
版权声明:本文发布于特牛网址导航 内容均来源于互联网 如有侵权联系删除