//根据时间条件查询表中,每天的数据统计次数SELECT DATE_FORMAT(`report_time` ,'%Y-%m-%d') as shijian,count(*) FROM <表名称> GROUP BY shijian;