select count(*), substring(scanning_time,12,2) from warning_results where scanning_time between '2017-08-10 00:00:00' and '2017-08-10 23:59:59' group by substring(scanning_time,12,2);
mysql timestamp类型字段按小时分组语句:select count(*), substring(scanning_time,12,2) from warning_results where scanning_time between '2017-08-10 00:00:00' and '2017-08-10 23:59:59' group by substring(scanning_t...