mysql分组查询最近的一条数据
DROP TABLE IF EXISTS `jt_mes_monitoring`;
CREATE TABLE `jt_mes_monitoring` (
`mes_id` bigint(30) NOT NULL COMMENT '消息ID',
`old_id` int(10) NULL DEFAULT NULL COMMENT '老人ID',
`old_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '老人姓名',
`receiving_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预警时间',
`main_device_id` varc
共有 0 条评论