- sql 的写法,假如查询出距离现在最近的那条记录
SELECT id,min(NOW()-updateTime) as time,`name` FROM dd GROUP BY id LIMIT 0,1
2.建表语句
DROP TABLE IF EXISTS `dd`;
CREATE TABLE `dd` (
`id` int(11) NOT NULL,
`name` varchar(50) DEFAULT NULL,
`updateTime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of dd
-- ----------------------------
BEGIN;
INSERT INTO `dd` VALUES (1, 'jack', '2019-04-22 09:42:35');
INSERT INTO `dd` VALUES (2, 'red', '2019-04-21 09:42:39');
INSERT INTO `dd` VALUES (3, 'tx', '2019-04-20 09:42:44');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;