<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[D3364的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/D3364</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; D3364]]></copyright><item><title><![CDATA[MySQL 模糊查询指南（以mysql为例）]]></title><link>https://blog.youkuaiyun.com/D3364/article/details/148291943</link><guid>https://blog.youkuaiyun.com/D3364/article/details/148291943</guid><author>D3364</author><pubDate>Thu, 29 May 2025 03:16:46 +0800</pubDate><description><![CDATA[通过LIKE结合%、_等通配符实现字符串模式匹配的方法，涵盖大小写处理、特殊字符转义、性能优化（如前缀匹配、全文索引）及复杂查询示例]]></description><category></category></item><item><title><![CDATA[SQL的 “反直觉” 设计]]></title><link>https://blog.youkuaiyun.com/D3364/article/details/148280221</link><guid>https://blog.youkuaiyun.com/D3364/article/details/148280221</guid><author>D3364</author><pubDate>Wed, 28 May 2025 12:22:07 +0800</pubDate><description><![CDATA[本文对比分析了 SQL 作为声明式查询语言与 C、Python 等过程式 / 面向对象语言在语法设计和编程范式上的 “反直觉” 差异]]></description><category></category></item><item><title><![CDATA[SQL 查询常见错误总结及修正方法（1）]]></title><link>https://blog.youkuaiyun.com/D3364/article/details/148267798</link><guid>https://blog.youkuaiyun.com/D3364/article/details/148267798</guid><author>D3364</author><pubDate>Wed, 28 May 2025 02:06:39 +0800</pubDate><description><![CDATA[主要总结了 SQL 查询中括号 / 引号使用错误、NOT IN 及 NOT EXISTS 误用等常见语法和逻辑错误，并详解 IN、NOT IN、IS、EXISTS 的用法及注意事项。]]></description><category></category></item><item><title><![CDATA[SQL 查询中常见关键字的正确顺序以及使用规则]]></title><link>https://blog.youkuaiyun.com/D3364/article/details/148253404</link><guid>https://blog.youkuaiyun.com/D3364/article/details/148253404</guid><author>D3364</author><pubDate>Tue, 27 May 2025 11:40:12 +0800</pubDate><description><![CDATA[选（SELECT）定表（FROM）筛（WHERE）分组（GROUP BY），
过滤（HAVING）排序（ORDER BY）限（LIMIT）数目；
去重（DISTINCT）列前加，别名（AS）后标注。]]></description><category></category></item></channel></rss>