mysql5.7 如何查询同一台设备时间间隔两小时的数据？ 也就说同一台设备 24小时取12条数据

Question

需求描述：数据是每十分钟写入一次（数据已存在），现在新需求是只展示时间间隔为两个小时的数据， 也就说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');

Answer 1

拿到当前时间两小时前的时间戳，数据库存入时间戳大于等于拿到的时间戳