mysql计算时间小时数_MySQL-按时间统计每个小时的记录数

-------------------------------------------------------------------------------------------------正文---------------------------------------------------------------------------------------------------------------

抽空在stack overflow转了一圈, 看到一个有关SQL的提问, 大概转述一下:

构造语句:

点击(此处)折叠或打开

CREATE TABLE `st` (

`id` varchar(8) NOT NULL,

`time` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

insert into st values('F41','2016-08-27 00:25:58');

insert into st values('F42','2016-08-27 01:15:03');

insert into st values('F43','2016-08-27 02:14:30');

insert into st values('F44','2016-08-27 02:24:12');

insert into st values('F45','2016-08-27 03:05:46');

insert into st values('F46','201