select date_format(createTime,'%Y-%m-%d') as 日期, count(1) as 数量 from t_bs_reqocrcode_log where createTime >= date(now()) - interval 7 day group by day(createTime);
统计7天之内每天的数目select date_format(createTime,'%Y-%m-%d') as 日期, count(1) as 数量 from t_bs_reqocrcode_log where createTime >= date(now()) - interval 7 day group by day(createTime);