需求描述:数据是每十分钟写入一次(数据已存在),现在新需求是只展示时间间隔为两个小时的数据, 也就说24小时取12条数据
表结构CREATE TABLE lara_realdata
(id
int(11) NOT NULL AUTO_INCREMENT,equipment_id
varchar(255) DEFAULT NULL COMMENT '设备编号',collection_time
int(11) DEFAULT NULL COMMENT '采集时间',instan_flow
varchar(11) DEFAULT NULL COMMENT '瞬时流量',
PRIMARY KEY (id
) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
添加语句
INSERT INTO laracms
.lara_realdata
( equipment_id
, collection_time
, instan_flow
) VALUES ('00000829', 1543466428, '0.06');
INSERT INTO laracms
.lara_realdata
(equipment_id
, collection_time
, instan_flow
) VALUES ('00000652', 1543466802, '0.52');
INSERT INTO laracms
.lara_realdata
(equipment_id
, collection_time
, instan_flow
) VALUES ('00000652', 1543466879, '0.16');
INSERT INTO laracms
.lara_realdata
( equipment_id
, collection_time
, instan_flow
) VALUES ('00000829', 1543466428, '0.06');
INSERT INTO laracms
.lara_realdata
(equipment_id
, collection_time
, instan_flow
) VALUES ('00000652', 1543466802, '0.52');
INSERT INTO laracms
.lara_realdata
(equipment_id
, collection_time
, instan_flow
) VALUES ('00000652', 1543466879, '0.16');