<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ayojin的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ayojin</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ayojin]]></copyright><item><title><![CDATA[python字典中，根据值确定键（值可为列表）]]></title><link>https://blog.youkuaiyun.com/ayojin/article/details/128021800</link><guid>https://blog.youkuaiyun.com/ayojin/article/details/128021800</guid><author>ayojin</author><pubDate>Thu, 24 Nov 2022 16:46:39 +0800</pubDate><description><![CDATA[覆写之前项目中的方法时候，感觉将原来的key变为value方便，于是乎，后续出现了根据值对应键的需求。写个方法保存个人学习用吧~]]></description><category></category></item><item><title><![CDATA[关于mysql大表中数量查询]]></title><link>https://blog.youkuaiyun.com/ayojin/article/details/127764955</link><guid>https://blog.youkuaiyun.com/ayojin/article/details/127764955</guid><author>ayojin</author><pubDate>Wed, 09 Nov 2022 11:19:24 +0800</pubDate><description><![CDATA[索引统计的值是通过采样来估算的。实际上，TABLE_ROWS 就是从这个采样估算得来的，因此它也很不准。实际操作时，面对数据量为亿级别的数据库查询速度邦慢。首先是mysql数据库中存有各个表的数据，以此可查。于是想着能不能快一点开始查询资料。]]></description><category></category></item><item><title><![CDATA[随手记录下学习]]></title><link>https://blog.youkuaiyun.com/ayojin/article/details/127648044</link><guid>https://blog.youkuaiyun.com/ayojin/article/details/127648044</guid><author>ayojin</author><pubDate>Wed, 02 Nov 2022 11:10:17 +0800</pubDate><description><![CDATA[SELECT JSON_SEARCH(userBelong,'one',3) FROM table_name始终为空。userBelong字段存储json格式[1,2,3]查阅资料后发现，json_search找不到整数类型。也就是说字段存储格式为整数的话，此方法搜索无效。ps：增加userBelong字段sql。更新也无效，白费好久时间0.0。对mysql数据库的处理。]]></description><category></category></item></channel></rss>