Mysql统计每周每月每季度每年不同类型的数量
-- 统计每日SELECT case_type_id,DATE_FORMAT(report_time,'%Y-%m-%d') as m,count(*) as count from `case` where is_simple=1 GROUP BY m, case_type_id ORDER BY m desc;# 每天不同类型的数据量SELECT b.name,DATE_FORMAT(report_time,'%Y-%m-%d') as m,count(*) as .