<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[YAYAYO1的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/YAYAYO1</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; YAYAYO1]]></copyright><item><title><![CDATA[mysql日期查询]]></title><link>https://blog.youkuaiyun.com/YAYAYO1/article/details/103491541</link><guid>https://blog.youkuaiyun.com/YAYAYO1/article/details/103491541</guid><author>YAYAYO1</author><pubDate>Wed, 11 Dec 2019 14:17:28 +0800</pubDate><description><![CDATA[mysql 一个sql求出当月每天的日期，用于统计每天数据一个sql查询最近7天的日期
select @d:=@d+1 number,
DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())-@d DAY) time
from
(select 1 UNION ALL select 2 UNION ALL select 3 UNION ALL select...]]></description><category></category></item></channel></rss>