<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[listen]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/listenman</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; listenman]]></copyright><item><title><![CDATA[mysql 查询距离某天最近的一条记录]]></title><link>https://blog.youkuaiyun.com/listenman/article/details/89447491</link><guid>https://blog.youkuaiyun.com/listenman/article/details/89447491</guid><author>listenman</author><pubDate>Mon, 22 Apr 2019 11:07:00 +0800</pubDate><description><![CDATA[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` va...]]></description><category></category></item></channel></rss>