<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[oREEFE的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/oREEFE</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; oREEFE]]></copyright><item><title><![CDATA[oracle 没有数据时显示一条空数据]]></title><link>https://blog.youkuaiyun.com/oREEFE/article/details/111401742</link><guid>https://blog.youkuaiyun.com/oREEFE/article/details/111401742</guid><author>oREEFE</author><pubDate>Sat, 19 Dec 2020 11:24:44 +0800</pubDate><description><![CDATA[最近在画报表， 有个嵌套列表， 当没有查询到数据时也要显示空表格



用union并集查询

利用rownum大于0的特性控制结果， 具体实现如下：

select rn, id,zgbzj,tzgsmc,tzje,cgbl from (
select rownum rn, id,zgbzj,tzgsmc,tzje,cgbl from TABLENAME z where jobid = $P{jobid}
union
select -1 rn,null,null,null,null,null fro...]]></description><category></category></item><item><title><![CDATA[mysql8.018误删除用户之后]]></title><link>https://blog.youkuaiyun.com/oREEFE/article/details/109528790</link><guid>https://blog.youkuaiyun.com/oREEFE/article/details/109528790</guid><author>oREEFE</author><pubDate>Fri, 06 Nov 2020 11:59:07 +0800</pubDate><description><![CDATA[使用SQLyog误删用户导致无法连接，错误信息： ERROR 1449 (HY000): The user specified as a definer (‘mysql.infoschema’@‘localhost’) does not exist
在网上找到的解决办法mysql_upgrade -u root -p
此方法在低版本下可用，
我的mysql版本是8.018，提示信息：he mysql_upgrade client is now deprecated. The actions executed]]></description><category></category></item></channel></rss>