{"id":852,"date":"2025-10-19T21:39:56","date_gmt":"2025-10-19T13:39:56","guid":{"rendered":"https:\/\/hueil.top\/?p=852"},"modified":"2026-05-04T17:04:12","modified_gmt":"2026-05-04T09:04:12","slug":"mysql%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/hueil.top\/?p=852","title":{"rendered":"MySQL\u6570\u636e\u5e93"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">\u4e00\uff0c\u4e0b\u8f7dMySQL<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd9\u662f\u4e0b\u8f7d\u5730\u5740\uff1a<a href=\"https:\/\/dev.mysql.com\/downloads\/mysql\">https:\/\/dev.mysql.com\/downloads\/mysql<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL\u4e0b\u8f7d-1024x793.webp'><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"793\" src=\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL\u4e0b\u8f7d-1024x793.webp\" alt=\"\" class=\"wp-image-859\" srcset=\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL\u4e0b\u8f7d-1024x793.webp 1024w, https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL\u4e0b\u8f7d-300x232.webp 300w, https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL\u4e0b\u8f7d-768x595.webp 768w, https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL\u4e0b\u8f7d.webp 1220w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">\u4e8c\uff0c\u5b89\u88c5\u6b65\u9aa4<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0b\u8f7d\u597d\u7684\u6587\u4ef6\uff0c\u89e3\u538b\u5230\u4f60\u60f3\u5b89\u88c5\u7684\u5730\u65b9<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/\u56fe\u7247-1.png'><img loading=\"lazy\" decoding=\"async\" width=\"933\" height=\"373\" src=\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/\u56fe\u7247-1.png\" alt=\"\" class=\"wp-image-853\" srcset=\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/\u56fe\u7247-1.png 933w, https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/\u56fe\u7247-1-300x120.png 300w, https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/\u56fe\u7247-1-768x307.png 768w\" sizes=\"auto, (max-width: 933px) 100vw, 933px\" \/><\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u89e3\u538b\u597d\u540e\uff0c\u9ed8\u8ba4\u662f\u6ca1\u6709my.ini\u6587\u4ef6\u7684\uff0c\u9700\u8981\u6211\u4eec\u81ea\u5df1\u521b\u5efa\u4e00\u4e2a\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;client]\n# \u8bbe\u7f6emysql\u5ba2\u6237\u7aef\u9ed8\u8ba4\u5b57\u7b26\u96c6\ndefault-character-set=utf8\n \n&#91;mysqld]\n# \u8bbe\u7f6e3306\u7aef\u53e3\nport = 3306\n# \u8bbe\u7f6emysql\u7684\u5b89\u88c5\u76ee\u5f55\nbasedir=D:\\\\Program_Files_self\\\\MySQL\n# \u8bbe\u7f6e mysql\u6570\u636e\u5e93\u7684\u6570\u636e\u7684\u5b58\u653e\u76ee\u5f55\uff0cMySQL 8+ \u4e0d\u9700\u8981\u4ee5\u4e0b\u914d\u7f6e\uff0c\u7cfb\u7edf\u81ea\u5df1\u751f\u6210\u5373\u53ef\uff0c\u5426\u5219\u6709\u53ef\u80fd\u62a5\u9519\n# datadir=D:\\\\Program_Files_self\\\\MySQL\\\\MySQLData\n# \u5141\u8bb8\u6700\u5927\u8fde\u63a5\u6570\nmax_connections=20\n# \u670d\u52a1\u7aef\u4f7f\u7528\u7684\u5b57\u7b26\u96c6\u9ed8\u8ba4\u4e3a8\u6bd4\u7279\u7f16\u7801\u7684latin1\u5b57\u7b26\u96c6\ncharacter-set-server=utf8\n# \u521b\u5efa\u65b0\u8868\u65f6\u5c06\u4f7f\u7528\u7684\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\ndefault-storage-engine=INNODB\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u547d\u4ee4\u884c\u64cd\u4f5c<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4ee5\u7ba1\u7406\u5458\u8eab\u4efd\u6253\u5f00 cmd \u547d\u4ee4\u884c\u5de5\u5177\uff0c\u6309\u4e0bShift+Ctrl+Enter\u952e\u5373\u53ef<\/li>\n\n\n\n<li>\u7528cd\u547d\u4ee4\u5207\u6362\u5230\u81ea\u5df1\u7684\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684 bin \u6587\u4ef6\u5939<\/li>\n\n\n\n<li>\u5982\u679c\u5728D\u76d8\uff0c\u518d\u952e\u5165D:\u5373\u53ef\u8fdb\u5165\u76ee\u5f55<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u5b89\u88c5\nmysqld install\n#\u521d\u59cb\u5316\u6570\u636e\u5e93\nmysqld --initialize --console\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6267\u884c\u5b8c\u6210\u540e\u4f1a\u8f93\u51fa root \u7528\u6237\u7684\u521d\u6b64\u5bc6\u7801<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/\u56fe\u7247-2.png'><img loading=\"lazy\" decoding=\"async\" width=\"318\" height=\"13\" src=\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/\u56fe\u7247-2.png\" alt=\"\" class=\"wp-image-854\" srcset=\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/\u56fe\u7247-2.png 318w, https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/\u56fe\u7247-2-300x13.png 300w\" sizes=\"auto, (max-width: 318px) 100vw, 318px\" \/><\/div><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u542f\u52a8\u670d\u52a1\nnet start mysql\n#\u767b\u5f55\nmysql -u root -p<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">\u9047\u5230\u7684\u95ee\u9898<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u73b0 \u201cERROR 1045 (28000): Access denied for user &#8216;root&#8217;@&#8217;<a href=\"https:\/\/localhost\/\" target=\"_blank\" rel=\"noreferrer noopener\">localhost<\/a>&#8216; (using password: YES)\u201d<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u89e3\u51b3\u65b9\u6848\uff1a<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u505c\u6b62MySQL\u670d\u52a1\nnet stop mysql\n#\u8df3\u8fc7\u6743\u9650\u9a8c\u8bc1\u542f\u52a8 MySQL\nmysqld --console --skip-grant-tables --shared-memory<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u65e0\u5bc6\u7801\u767b\u5f55\u5e76\u91cd\u7f6e\u5bc6\u7801<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u91cd\u65b0\u6253\u5f00\u4e00\u4e2a<strong>\u65b0\u7684 CMD \u7a97\u53e3<\/strong>\uff0c\u8fdb\u5165<code>bin<\/code>\u76ee\u5f55<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u767b\u5f55\nmysql -u root -p\n#\u63d0\u793a\u8f93\u5165\u5bc6\u7801\u65f6\uff0c\u76f4\u63a5\u6309\u56de\u8f66\uff08\u65e0\u5bc6\u7801\u767b\u5f55\uff09\n#\u767b\u5f55\u540e\uff0c\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u91cd\u7f6e\u5bc6\u7801\uff08\u66ff\u6362\u65b0\u5bc6\u7801\u4e3a\u4f60\u7684\u5bc6\u7801\uff09\n-- \u5207\u6362\u5230mysql\u7cfb\u7edf\u6570\u636e\u5e93\nuse mysql;\n-- \u91cd\u7f6eroot\u5bc6\u7801\uff08MySQL 8.0+ \u5fc5\u987b\u7528\u6b64\u8bed\u6cd5\uff09\nALTER USER 'root'@'localhost' IDENTIFIED BY '\u65b0\u5bc6\u7801';\n-- \u5237\u65b0\u6743\u9650\nFLUSH PRIVILEGES;\n-- \u9000\u51fa\nexit;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u91cd\u542f MySQL \u670d\u52a1\uff1a<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5173\u95ed\u4e4b\u524d \u201c\u8df3\u8fc7\u6743\u9650\u9a8c\u8bc1\u201d \u7684 CMD \u7a97\u53e3\uff08\u505c\u6b62\u4e34\u65f6\u670d\u52a1\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u65b0 CMD \u7a97\u53e3\u4e2d\u542f\u52a8\u670d\u52a1\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>net start mysql<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">\u5176\u4ed6<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">mysql&gt; ALTER USER &#8216;root&#8217;@&#8217;<a href=\"https:\/\/localhost\/\" target=\"_blank\" rel=\"noreferrer noopener\">localhost<\/a>&#8216; IDENTIFIED BY &#8216;root&#8217;; ERROR 1290 (HY000): The MySQL server is running with the &#8211;skip-grant-tables option so it cannot execute this statement<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u51fa\u73b0\u4ee5\u4e0a\u95ee\u9898\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5148\u5237\u65b0\u6743\u9650\uff0c\u518d\u4fee\u6539\u5bc6\u7801<\/strong>\uff0c\u5177\u4f53\u6b65\u9aa4\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>FLUSH PRIVILEGES;\nALTER USER 'root'@'localhost' IDENTIFIED BY 'root';\nFLUSH PRIVILEGES;\nexit;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e4b\u540e\u6309\u4e4b\u524d\u7684\u6b65\u9aa4\u5173\u95ed\u4e34\u65f6\u542f\u52a8\u7684 MySQL \u7a97\u53e3\uff0c\u91cd\u65b0\u542f\u52a8\u6b63\u5e38\u7684 MySQL \u670d\u52a1\uff0c\u5373\u53ef\u7528\u65b0\u5bc6\u7801\u767b\u5f55\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Navicat\u5b89\u88c5<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/blog.csdn.net\/camlin\/article\/details\/147079318?ops_request_misc=elastic_search_misc&amp;request_id=d50d24ebd11674c747efdef1a17f1903&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~top_positive~default-1-147079318-null-null.142^v102^pc_search_result_base1&amp;utm_term=navicat16%E7%A0%B4%E8%A7%A3%E7%89%88%E5%AE%89%E8%A3%85%E6%95%99%E7%A8%8B&amp;spm=1018.2226.3001.4187\">Navicat Premium 16 \u4fdd\u59c6\u7ea7\u624b\u628a\u624b \u5b89\u88c5\u6559\u7a0b\u5305\u542b\u4e0b\u8f7d\u3001\u5b89\u88c5\u3001\u6388\u6743\uff08\u9644\u5b89\u88c5\u5305\uff09-CSDN\u535a\u5ba2<\/a><\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Mysql\u4f7f\u7528<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Mysql\u6570\u636e\u5e93\u901a\u8fc7SQL\uff08\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\uff09\u8bed\u53e5\u5bf9\u6570\u636e\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL\u64cd\u4f5c\u8bed\u53e5\u53ef\u4ee5\u5206\u4e3a\u4e09\u79cd:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DDL(\u6570\u636e\u5b9a\u4e49\u8bed\u8a00)<\/li>\n\n\n\n<li>DML(\u6570\u636e\u64cd\u4f5c\u8bed\u8a00)<\/li>\n\n\n\n<li>DQL(\u6570\u636e\u67e5\u8be2\u8bed\u8a00)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">DDL(\u6570\u636e\u5b9a\u4e49\u8bed\u8a00)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f5c\u7528:\u5b9a\u4e49\u548c\u7ba1\u7406\u6570\u636e\u5e93\u3001\u8868\u7684\u7ed3\u6784\u3002<br>\u5173\u952e\u5b57:CREATE,ALTER,DROP<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">DML(\u6570\u636e\u64cd\u4f5c\u8bed\u8a00)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f5c\u7528:\u5bf9\u8868\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u589e\u3001\u5220\u3001\u6539\u3002<br>\u5173\u952e\u5b57:INSERT,UPDATE,DELETE<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">DQL(\u6570\u636e\u67e5\u8be2\u8bed\u8a00)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f5c\u7528:\u67e5\u8be2\u8868\u4e2d\u7684\u6570\u636e\u3002<br>\u5173\u952e\u5b57:SELECT<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">\u67e5\u8be2<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u6761\u4ef6\u67e5\u8be2\uff0c\u5982\u4e00\u6761\u5b8c\u6574\u7684sql\u67e5\u8be2\u8bed\u53e5\u7ed3\u6784\u4e3a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT &#91;DISTINCT] \u5217\u540d1, \u5217\u540d2, ...  -- \u8981\u67e5\u8be2\u7684\u5217\uff08* \u8868\u793a\u6240\u6709\u5217\uff09\nFROM \u8868\u540d                            -- \u6570\u636e\u6765\u6e90\u7684\u8868\n&#91;JOIN \u5173\u8054\u8868\u540d ON \u5173\u8054\u6761\u4ef6]          -- \u591a\u8868\u5173\u8054\uff08\u53ef\u9009\uff09\n&#91;WHERE \u7b5b\u9009\u6761\u4ef6]                     -- \u884c\u7ea7\u8fc7\u6ee4\uff08\u6838\u5fc3\uff1a\u6761\u4ef6\u67e5\u8be2\uff09\n&#91;GROUP BY \u5206\u7ec4\u5217]                    -- \u5206\u7ec4\uff08\u53ef\u9009\uff09\n&#91;HAVING \u5206\u7ec4\u540e\u7b5b\u9009\u6761\u4ef6]              -- \u5206\u7ec4\u540e\u8fc7\u6ee4\uff08\u53ef\u9009\uff09\n&#91;ORDER BY \u6392\u5e8f\u5217 &#91;ASC\/DESC]]         -- \u6392\u5e8f\uff08\u53ef\u9009\uff09\n&#91;LIMIT \u884c\u6570 &#91;OFFSET \u504f\u79fb\u91cf]]         -- \u9650\u5236\u7ed3\u679c\u884c\u6570\uff08\u53ef\u9009\uff0c\u4e0d\u540c\u6570\u636e\u5e93\u8bed\u6cd5\u7565\u6709\u5dee\u5f02\uff09<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u57fa\u7840\u7ed3\u6784<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u57fa\u7840\u7ed3\u6784\uff1aSELECT + FROM + WHERE\nSELECT name, age \nFROM student \nWHERE gender = '\u5973' AND age &gt; 18;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><code>SELECT<\/code>\uff1a\u6307\u5b9a\u9700\u8981\u67e5\u8be2\u7684\u5b57\u6bb5\uff0c\u4f7f\u7528<code>*<\/code>\u8868\u793a\u67e5\u8be2\u6240\u6709\u5b57\u6bb5 <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>FROM<\/code>\uff1a\u6307\u5b9a\u6570\u636e\u6765\u6e90\u7684\u8868\u540d <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>WHERE<\/code>\uff1a\u5b9a\u4e49\u7b5b\u9009\u6761\u4ef6\uff0c\u53ea\u6709\u6ee1\u8db3\u8be5\u6761\u4ef6\u7684\u8bb0\u5f55\u624d\u4f1a\u88ab\u8fd4\u56de<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u5e38\u7528\u8fd0\u7b97\u7b26<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u6bd4\u8f83\u8fd0\u7b97\u7b26<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6bd4\u8f83\u8fd0\u7b97\u7b26\u662f\u6700\u57fa\u7840\u7684\u6761\u4ef6\u5224\u65ad\u5de5\u5177\uff0c\u7528\u4e8e\u5224\u65ad\u5b57\u6bb5\u503c\u4e0e\u76ee\u6807\u503c\u7684\u5173\u7cfb\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>=<\/code>\uff1a\u7b49\u4e8e<\/li>\n\n\n\n<li><code>!=<\/code>\/<code>&lt;&gt;<\/code>\uff1a\u4e0d\u7b49\u4e8e<\/li>\n\n\n\n<li><code>&gt;<\/code>\uff1a\u5927\u4e8e<\/li>\n\n\n\n<li><code>&lt;<\/code>\uff1a\u5c0f\u4e8e<\/li>\n\n\n\n<li><code>&gt;=<\/code>\uff1a\u5927\u4e8e\u7b49\u4e8e<\/li>\n\n\n\n<li><code>&lt;=<\/code>\uff1a\u5c0f\u4e8e\u7b49\u4e8e<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2. \u8303\u56f4\u8fd0\u7b97\u7b26<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5f53\u9700\u8981\u5224\u65ad\u5b57\u6bb5\u503c\u662f\u5426\u5728\u67d0\u4e2a\u8fde\u7eed\u533a\u95f4\u65f6\uff0c\u4f7f\u7528<code>BETWEEN ... AND ...<\/code>\u4f1a\u8ba9\u8bed\u53e5\u66f4\u7b80\u6d01\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u67e5\u8be2\u5e74\u9f84\u572818\u523025\u5c81\u4e4b\u95f4\u7684\u5b66\u751f\nSELECT * FROM student WHERE age BETWEEN 18 AND 25;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. \u6a21\u7cca\u5339\u914d<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u7528<code>LIKE<\/code>\u5173\u952e\u5b57\u53ef\u4ee5\u5b9e\u73b0\u6a21\u7cca\u67e5\u8be2\uff0c\u901a\u5e38\u914d\u5408\u901a\u914d\u7b26\u4f7f\u7528\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>%<\/code>\uff1a\u5339\u914d\u4efb\u610f\u957f\u5ea6\u7684\u4efb\u610f\u5b57\u7b26\uff08\u5305\u62ec 0 \u4e2a\u5b57\u7b26\uff09<\/li>\n\n\n\n<li><code>_<\/code>\uff1a\u5339\u914d\u5355\u4e2a\u4efb\u610f\u5b57\u7b26<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u67e5\u8be2\u59d3\u5f20\u7684\u5b66\u751f\nSELECT * FROM student WHERE name LIKE '\u5f20%';\n-- \u67e5\u8be2\u540d\u5b57\u4e3a\u4e24\u4e2a\u5b57\u4e14\u59d3\u5f20\u7684\u5b66\u751f\nSELECT * FROM student WHERE name LIKE '\u5f20_';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">4. \u96c6\u5408\u8fd0\u7b97\u7b26<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><code>IN<\/code>\u5173\u952e\u5b57\u7528\u4e8e\u5224\u65ad\u5b57\u6bb5\u503c\u662f\u5426\u5c5e\u4e8e\u6307\u5b9a\u7684\u96c6\u5408\uff0c\u9002\u5408\u5904\u7406\u79bb\u6563\u7684\u591a\u4e2a\u53d6\u503c\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u67e5\u8be2\u5b66\u53f7\u4e3a1001\u30011003\u30011005\u7684\u5b66\u751f\nSELECT * FROM student WHERE id IN (1001, 1003, 1005);<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">SQL \u8fde\u63a5\u67e5\u8be2\uff1aLEFT JOIN \u4e0e RIGHT JOIN \u8be6\u89e3<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u591a\u8868\u5173\u8054\u67e5\u8be2\u7684\u573a\u666f\u4e2d\uff0c<code>LEFT JOIN<\/code>\uff08\u5de6\u8fde\u63a5\uff09\u548c<code>RIGHT JOIN<\/code>\uff08\u53f3\u8fde\u63a5\uff09\u662f\u5b9e\u73b0\u6570\u636e\u5173\u8054\u7684\u6838\u5fc3\u65b9\u5f0f\uff0c\u4e8c\u8005\u7684\u6838\u5fc3\u533a\u522b\u5728\u4e8e\u4fdd\u7559\u7684\u8868\u6570\u636e\u4e0d\u540c\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u3001LEFT JOIN\uff08\u5de6\u8fde\u63a5\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6838\u5fc3\u7279\u70b9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u6570\u636e\u4fdd\u7559\u89c4\u5219<\/strong>\uff1a\u4fdd\u7559\u5de6\u8868\uff08<code>FROM<\/code>\u540e\u7684\u7b2c\u4e00\u4e2a\u8868\uff09\u7684\u6240\u6709\u8bb0\u5f55\uff0c\u5373\u4f7f\u53f3\u8868\u4e2d\u6ca1\u6709\u5339\u914d\u7684\u8bb0\u5f55\u3002<\/li>\n\n\n\n<li><strong>\u65e0\u5339\u914d\u5904\u7406<\/strong>\uff1a\u5f53\u53f3\u8868\u65e0\u5339\u914d\u8bb0\u5f55\u65f6\uff0c\u53f3\u8868\u5bf9\u5e94\u7684\u5b57\u6bb5\u4f1a\u663e\u793a\u4e3a<code>NULL<\/code>\u3002<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u57fa\u7840\u8bed\u6cd5<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \u5b57\u6bb5 FROM \u88681 LEFT JOIN \u88682 ON \u5173\u8054\u6761\u4ef6;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u5e94\u7528\u573a\u666f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9002\u7528\u4e8e\u9700\u8981\u4ee5\u5de6\u8868\u6570\u636e\u4e3a\u57fa\u7840\uff0c\u5173\u8054\u53f3\u8868\u8865\u5145\u4fe1\u606f\u7684\u573a\u666f\uff0c\u4f8b\u5982\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u8be2\u6240\u6709\u5b66\u751f\u7684\u9009\u8bfe\u4fe1\u606f\uff0c\u5305\u62ec\u6ca1\u6709\u9009\u8bfe\u7684\u5b66\u751f<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT student.name, course.course_name\nFROM student LEFT JOIN course\nON student.id = course.student_id;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001RIGHT JOIN\uff08\u53f3\u8fde\u63a5\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6838\u5fc3\u7279\u70b9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u6570\u636e\u4fdd\u7559\u89c4\u5219<\/strong>\uff1a\u4fdd\u7559\u53f3\u8868\uff08<code>JOIN<\/code>\u540e\u7684\u8868\uff09\u7684\u6240\u6709\u8bb0\u5f55\uff0c\u5373\u4f7f\u5de6\u8868\u4e2d\u6ca1\u6709\u5339\u914d\u7684\u8bb0\u5f55\u3002<\/li>\n\n\n\n<li><strong>\u65e0\u5339\u914d\u5904\u7406<\/strong>\uff1a\u5f53\u5de6\u8868\u65e0\u5339\u914d\u8bb0\u5f55\u65f6\uff0c\u5de6\u8868\u5bf9\u5e94\u7684\u5b57\u6bb5\u4f1a\u663e\u793a\u4e3a<code>NULL<\/code>\u3002<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u57fa\u7840\u8bed\u6cd5<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \u5b57\u6bb5 FROM \u88681 RIGHT JOIN \u88682 ON \u5173\u8054\u6761\u4ef6;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u5e94\u7528\u573a\u666f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9002\u7528\u4e8e\u9700\u8981\u4ee5\u53f3\u8868\u6570\u636e\u4e3a\u57fa\u7840\uff0c\u5173\u8054\u5de6\u8868\u8865\u5145\u4fe1\u606f\u7684\u573a\u666f\uff0c\u4f8b\u5982\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u8be2\u6240\u6709\u8bfe\u7a0b\u7684\u9009\u8bfe\u5b66\u751f\uff0c\u5305\u62ec\u6ca1\u6709\u5b66\u751f\u9009\u62e9\u7684\u8bfe\u7a0b<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT student.name, course.course_name\nFROM student RIGHT JOIN course\nON student.id = course.student_id;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u6838\u5fc3\u533a\u522b\u5bf9\u6bd4<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u7ef4\u5ea6<\/th><th class=\"has-text-align-center\" data-align=\"center\">LEFT JOIN<\/th><th class=\"has-text-align-center\" data-align=\"center\">RIGHT JOIN<\/th><\/tr><\/thead><tbody><tr><td>\u4fdd\u7559\u7684\u8868<\/td><td>\u5de6\u8868<\/td><td>\u53f3\u8868<\/td><\/tr><tr><td>\u65e0\u5339\u914d\u65f6\u7684\u5b57\u6bb5\u503c<\/td><td>\u53f3\u8868\u5b57\u6bb5\u4e3a NULL<\/td><td>\u5de6\u8868\u5b57\u6bb5\u4e3a NULL<\/td><\/tr><tr><td>\u5178\u578b\u4f7f\u7528\u573a\u666f<\/td><td>\u4ee5\u5de6\u8868\u4e3a\u4e3b\uff0c\u8865\u5145\u53f3\u8868\u4fe1\u606f<\/td><td>\u4ee5\u53f3\u8868\u4e3a\u4e3b\uff0c\u8865\u5145\u5de6\u8868\u4fe1\u606f<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">ER \u56fe\u4e0e\u7269\u7406\u8868\u7684\u5173\u7cfb\u89e3\u6790<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">ER \u56fe\u662f\u6570\u636e\u5e93\u8bbe\u8ba1\u7684\u84dd\u56fe\uff0c\u800c\u7269\u7406\u8868\u662f\u5176\u5728\u6570\u636e\u5e93\u4e2d\u7684\u6700\u7ec8\u5b9e\u73b0\uff0c\u4e8c\u8005\u5171\u540c\u6784\u6210\u4e86\u4ece\u6570\u636e\u5efa\u6a21\u5230\u6570\u636e\u5b58\u50a8\u7684\u5b8c\u6574\u94fe\u8def\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u3001ER \u56fe\uff1a\u6570\u636e\u5e93\u7684\u8bbe\u8ba1\u84dd\u56fe<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b9a\u4e49<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ER \u56fe\uff08\u5b9e\u4f53 &#8211; \u5173\u7cfb\u56fe\uff09\u662f\u7528\u56fe\u5f62\u5316\u65b9\u5f0f\u63cf\u8ff0\u6570\u636e\u53ca\u5176\u5173\u7cfb\u7684\u5de5\u5177\uff0c\u662f\u6570\u636e\u5e93\u8bbe\u8ba1\u9636\u6bb5\u7684\u6838\u5fc3\u4ea7\u51fa\u7269\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6838\u5fc3\u4e09\u8981\u7d20<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u5b9e\u4f53\uff08Entity\uff09<\/strong>\uff1a\u7528\u77e9\u5f62\u8868\u793a\uff0c\u5bf9\u5e94\u4e1a\u52a1\u4e2d\u7684\u6838\u5fc3\u5bf9\u8c61\uff0c\u4f8b\u5982 \u201c\u5b66\u751f\u201d\u201c\u8bfe\u7a0b\u201d\u3002<\/li>\n\n\n\n<li><strong>\u5c5e\u6027\uff08Attribute\uff09<\/strong>\uff1a\u7528\u692d\u5706\u5f62\u8868\u793a\uff0c\u662f\u5b9e\u4f53\u7684\u7279\u5f81\uff0c\u4f8b\u5982\u5b66\u751f\u7684 \u201c\u59d3\u540d\u201d\u201c\u5e74\u9f84\u201d\u3002<\/li>\n\n\n\n<li><strong>\u5173\u7cfb\uff08Relationship\uff09<\/strong>\uff1a\u7528\u83f1\u5f62\u8868\u793a\uff0c\u63cf\u8ff0\u5b9e\u4f53\u4e4b\u95f4\u7684\u5173\u8054\uff0c\u4f8b\u5982\u5b66\u751f \u201c\u9009\u8bfe\u201d\u3002<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u6838\u5fc3\u4f5c\u7528<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6e05\u6670\u89c4\u5212\u6570\u636e\u7ed3\u6784\u4e0e\u4e1a\u52a1\u5173\u7cfb\uff0c\u63d0\u524d\u68b3\u7406\u6570\u636e\u4e4b\u95f4\u7684\u4f9d\u8d56\uff0c\u4e3a\u540e\u7eed\u7269\u7406\u8868\u7684\u521b\u5efa\u63d0\u4f9b\u660e\u786e\u4f9d\u636e\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u7269\u7406\u8868\uff1aER \u56fe\u7684\u5177\u4f53\u5b9e\u73b0<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b9a\u4e49<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7269\u7406\u8868\u662f ER \u56fe\u5728\u6570\u636e\u5e93\u4e2d\u7684\u5177\u4f53\u5b9e\u73b0\uff0c\u662f\u771f\u5b9e\u5b58\u50a8\u6570\u636e\u7684\u4e8c\u7ef4\u8868\u7ed3\u6784\uff0c\u4e5f\u662f\u6240\u6709 SQL \u64cd\u4f5c\uff08\u589e\u5220\u6539\u67e5\uff09\u7684\u6700\u7ec8\u5bf9\u8c61\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e0e ER \u56fe\u7684\u5bf9\u5e94\u5173\u7cfb<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">ER \u56fe\u5143\u7d20<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u7269\u7406\u8868\u5bf9\u5e94\u9879<\/th><\/tr><\/thead><tbody><tr><td>\u5b9e\u4f53\uff08Entity\uff09<\/td><td>\u8868\uff08Table\uff09<\/td><\/tr><tr><td>\u5c5e\u6027\uff08Attribute\uff09<\/td><td>\u5b57\u6bb5\uff08\u5217 \/ Column\uff09<\/td><\/tr><tr><td>\u5173\u7cfb\uff08Relationship\uff09<\/td><td>\u4e3b\u952e \/ \u5916\u952e\uff08Primary Key\/Foreign Key\uff09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u6838\u5fc3\u4f5c\u7528<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f5c\u4e3a\u6570\u636e\u7684\u6700\u7ec8\u8f7d\u4f53\uff0c\u901a\u8fc7\u5b9a\u4e49\u5b57\u6bb5\u7c7b\u578b\u3001\u7ea6\u675f\u548c\u5173\u8054\uff0c\u5c06 ER \u56fe\u7684\u8bbe\u8ba1\u8f6c\u5316\u4e3a\u53ef\u64cd\u4f5c\u7684\u6570\u636e\u5e93\u5bf9\u8c61\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u4ece ER \u56fe\u5230\u7269\u7406\u8868\u7684\u8bbe\u8ba1\u6d41\u7a0b<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u9700\u6c42\u68b3\u7406<\/strong>\uff1a\u5206\u6790\u4e1a\u52a1\u573a\u666f\uff0c\u8bc6\u522b\u6838\u5fc3\u5b9e\u4f53\u3001\u5c5e\u6027\u4e0e\u5173\u7cfb\u3002<\/li>\n\n\n\n<li><strong>\u7ed8\u5236 ER \u56fe<\/strong>\uff1a\u7528\u56fe\u5f62\u5316\u65b9\u5f0f\u5448\u73b0\u6570\u636e\u6a21\u578b\uff0c\u9a8c\u8bc1\u4e1a\u52a1\u903b\u8f91\u7684\u5408\u7406\u6027\u3002<\/li>\n\n\n\n<li><strong>\u8868\u7ed3\u6784\u8bbe\u8ba1<\/strong>\uff1a\u5c06 ER \u56fe\u7684\u5b9e\u4f53\u8f6c\u5316\u4e3a\u8868\uff0c\u5c5e\u6027\u8f6c\u5316\u4e3a\u5b57\u6bb5\uff0c\u5173\u7cfb\u8f6c\u5316\u4e3a\u952e\u7ea6\u675f\u3002<\/li>\n\n\n\n<li><strong>\u6570\u636e\u5e93\u843d\u5730<\/strong>\uff1a\u901a\u8fc7<code>CREATE TABLE<\/code>\u7b49 SQL \u8bed\u53e5\u521b\u5efa\u7269\u7406\u8868\uff0c\u5b8c\u6210\u4ece\u8bbe\u8ba1\u5230\u5b58\u50a8\u7684\u8f6c\u5316\u3002<\/li>\n<\/ol>\n\n\n\n<h1 class=\"wp-block-heading\">\u6570\u636e\u5e93\u64cd\u4f5c\uff08Database\uff09<\/h1>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u521b\u5efa\u6570\u636e\u5e93<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u57fa\u7840\u8bed\u6cd5\nCREATE DATABASE &#91;IF NOT EXISTS] \u6570\u636e\u5e93\u540d \n&#91;DEFAULT CHARACTER SET \u5b57\u7b26\u96c6] \n&#91;DEFAULT COLLATE \u6392\u5e8f\u89c4\u5219];\n\n-- \u793a\u4f8b\uff1a\u521b\u5efa\u540d\u4e3aschool\u7684\u6570\u636e\u5e93\uff0c\u6307\u5b9aUTF8\u5b57\u7b26\u96c6\nCREATE DATABASE IF NOT EXISTS school \nDEFAULT CHARACTER SET utf8 \nDEFAULT COLLATE utf8_general_ci;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><code>IF NOT EXISTS<\/code>\uff1a\u907f\u514d\u91cd\u590d\u521b\u5efa\u62a5\u9519\uff08\u63a8\u8350\u5fc5\u52a0\uff09 <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5e38\u7528\u5b57\u7b26\u96c6\uff1a<code>utf8<\/code>\u3001<code>utf8mb4<\/code>\uff08\u652f\u6301 emoji\uff09<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5220\u9664\u6570\u636e\u5e93<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u57fa\u7840\u8bed\u6cd5\nDROP DATABASE &#91;IF EXISTS] \u6570\u636e\u5e93\u540d;\n\n-- \u793a\u4f8b\uff1a\u5220\u9664school\u6570\u636e\u5e93\nDROP DATABASE IF EXISTS school;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u9009\u62e9\u6570\u636e\u5e93<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>USE school; -- \u5207\u6362\u5230school\u6570\u636e\u5e93<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u6570\u636e\u8868\u64cd\u4f5c\uff08Table\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u521b\u5efa\u6570\u636e\u8868<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u57fa\u7840\u8bed\u6cd5\nCREATE TABLE &#91;IF NOT EXISTS] \u8868\u540d (\n    \u5b57\u6bb51 \u6570\u636e\u7c7b\u578b &#91;\u7ea6\u675f\u6761\u4ef6],\n    \u5b57\u6bb52 \u6570\u636e\u7c7b\u578b &#91;\u7ea6\u675f\u6761\u4ef6],\n    ...\n    &#91;\u8868\u7ea7\u7ea6\u675f]\n) &#91;ENGINE=\u5b58\u50a8\u5f15\u64ce] &#91;DEFAULT CHARSET=\u5b57\u7b26\u96c6];\n\n-- \u793a\u4f8b\uff1a\u521b\u5efastudent\u5b66\u751f\u8868\nCREATE TABLE IF NOT EXISTS student (\n    id INT PRIMARY KEY AUTO_INCREMENT, -- \u4e3b\u952e+\u81ea\u589e\n    name VARCHAR(50) NOT NULL, -- \u59d3\u540d\uff0c\u975e\u7a7a\n    age TINYINT UNSIGNED DEFAULT 18, -- \u5e74\u9f84\uff0c\u65e0\u7b26\u53f7\uff0c\u9ed8\u8ba418\n    gender ENUM('\u7537','\u5973','\u672a\u77e5') DEFAULT '\u672a\u77e5', -- \u6027\u522b\uff0c\u679a\u4e3e\u7c7b\u578b\n    create_time DATETIME DEFAULT CURRENT_TIMESTAMP -- \u521b\u5efa\u65f6\u95f4\uff0c\u9ed8\u8ba4\u5f53\u524d\u65f6\u95f4\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5e38\u7528\u7ea6\u675f\uff1a<code>PRIMARY KEY<\/code>\uff08\u4e3b\u952e\uff09\u3001<code>NOT NULL<\/code>\uff08\u975e\u7a7a\uff09\u3001<code>UNIQUE<\/code>\uff08\u552f\u4e00\uff09\u3001<code>DEFAULT<\/code>\uff08\u9ed8\u8ba4\u503c\uff09\u3001<code>AUTO_INCREMENT<\/code>\uff08\u81ea\u589e\uff09 <\/li>\n\n\n\n<li>\u5e38\u7528\u5b58\u50a8\u5f15\u64ce\uff1a<code>InnoDB<\/code>\uff08\u652f\u6301\u4e8b\u52a1 \/ \u5916\u952e\uff0c\u63a8\u8350\uff09\u3001<code>MyISAM<\/code><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u5220\u9664\u6570\u636e\u8868<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u57fa\u7840\u8bed\u6cd5\nDROP TABLE &#91;IF EXISTS] \u8868\u540d;\n\n-- \u793a\u4f8b\uff1a\u5220\u9664student\u8868\nDROP TABLE IF EXISTS student;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u6570\u636e\u64cd\u4f5c\uff08\u589e\u5220\u6539\u67e5 CRUD\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u65b0\u589e\u6570\u636e\uff08CREATE &#8211; INSERT\uff09<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u65b9\u5f0f1\uff1a\u6307\u5b9a\u5b57\u6bb5\u63d2\u5165\uff08\u63a8\u8350\uff0c\u5b57\u6bb5\u987a\u5e8f\u53ef\u81ea\u5b9a\u4e49\uff09\nINSERT INTO \u8868\u540d (\u5b57\u6bb51, \u5b57\u6bb52, ...) VALUES (\u503c1, \u503c2, ...);\n\n-- \u65b9\u5f0f2\uff1a\u63d2\u5165\u591a\u6761\u6570\u636e\uff08\u9ad8\u6548\uff09\nINSERT INTO \u8868\u540d (\u5b57\u6bb51, \u5b57\u6bb52) VALUES \n(\u503c1, \u503c2),\n(\u503c3, \u503c4);\n\n-- \u793a\u4f8b\uff1a\u63d2\u5165\u5355\u6761\u5b66\u751f\u6570\u636e\nINSERT INTO student (name, age, gender) VALUES ('\u5f20\u4e09', 20, '\u7537');\n\n-- \u793a\u4f8b\uff1a\u63d2\u5165\u591a\u6761\u5b66\u751f\u6570\u636e\nINSERT INTO student (name, age, gender) VALUES \n('\u674e\u56db', 21, '\u5973'),\n('\u738b\u4e94', 19, '\u7537');<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u67e5\u8be2\u6570\u636e\uff08READ &#8211; SELECT\uff09<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u57fa\u7840\u8bed\u6cd5\nSELECT &#91;DISTINCT] \u5b57\u6bb51, \u5b57\u6bb52, ... -- DISTINCT\u53bb\u91cd\nFROM \u8868\u540d\n&#91;WHERE \u6761\u4ef6] -- \u7b5b\u9009\u6761\u4ef6\n&#91;ORDER BY \u5b57\u6bb5 &#91;ASC\/DESC]] -- \u6392\u5e8f\uff0cASC\u5347\u5e8f\uff08\u9ed8\u8ba4\uff09\uff0cDESC\u964d\u5e8f\n&#91;LIMIT \u8d77\u59cb\u4f4d\u7f6e, \u6761\u6570]; -- \u5206\u9875\n\n-- \u793a\u4f8b1\uff1a\u67e5\u8be2\u6240\u6709\u5b66\u751f\u4fe1\u606f\nSELECT * FROM student;\n\n-- \u793a\u4f8b2\uff1a\u67e5\u8be2\u5e74\u9f84\u5927\u4e8e19\u7684\u7537\u751f\uff0c\u6309\u5e74\u9f84\u964d\u5e8f\nSELECT name, age FROM student \nWHERE age &gt; 19 AND gender = '\u7537'\nORDER BY age DESC;\n\n-- \u793a\u4f8b3\uff1a\u5206\u9875\u67e5\u8be2\uff0c\u7b2c1\u9875\uff08\u4ece0\u5f00\u59cb\uff09\uff0c\u6bcf\u987510\u6761\nSELECT * FROM student LIMIT 0, 10;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u66f4\u65b0\u6570\u636e\uff08UPDATE\uff09<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u57fa\u7840\u8bed\u6cd5\nUPDATE \u8868\u540d \nSET \u5b57\u6bb51=\u503c1, \u5b57\u6bb52=\u503c2, ...\n&#91;WHERE \u6761\u4ef6]; -- \u5fc5\u52a0\uff01\u5426\u5219\u66f4\u65b0\u5168\u8868\u6570\u636e\n\n-- \u793a\u4f8b\uff1a\u5c06\u5f20\u4e09\u7684\u5e74\u9f84\u6539\u4e3a22\nUPDATE student \nSET age = 22 \nWHERE name = '\u5f20\u4e09';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f <strong>\u91cd\u8981<\/strong>\uff1aUPDATE \u8bed\u53e5\u5fc5\u987b\u52a0 WHERE \u6761\u4ef6\uff0c\u5426\u5219\u4f1a\u4fee\u6539\u8868\u4e2d\u6240\u6709\u8bb0\u5f55\uff01<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5220\u9664\u6570\u636e\uff08DELETE\uff09<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u57fa\u7840\u8bed\u6cd5\nDELETE FROM \u8868\u540d &#91;WHERE \u6761\u4ef6]; -- \u5fc5\u52a0\uff01\u5426\u5219\u5220\u9664\u5168\u8868\u6570\u636e\n\n-- \u793a\u4f8b\uff1a\u5220\u9664\u59d3\u540d\u4e3a\u738b\u4e94\u7684\u5b66\u751f\nDELETE FROM student WHERE name = '\u738b\u4e94';\n\n-- \u6e05\u7a7a\u8868\uff08\u81ea\u589e\u4e3b\u952e\u91cd\u7f6e\uff0c\u614e\u7528\uff09\nTRUNCATE TABLE student;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>ELETE<\/code>\uff1a\u5220\u9664\u6570\u636e\uff0c\u81ea\u589e\u4e3b\u952e\u4e0d\u91cd\u7f6e\uff0c\u53ef\u56de\u6eda\uff08\u4e8b\u52a1\u4e2d\uff09<\/li>\n\n\n\n<li><code>TRUNCATE<\/code>\uff1a\u6e05\u7a7a\u8868\u5e76\u91cd\u7f6e\u7ed3\u6784\uff0c\u4e0d\u53ef\u56de\u6eda\uff0c\u6548\u7387\u66f4\u9ad8<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL\u5fc5\u77e5\u5fc5\u4f1a<\/h1>\n\n\n\n<h3 class=\"wp-block-heading\">\u6ce8\u91ca\uff1a<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7b80\u77ed\u5355\u884c<\/strong>\uff1a\u4f18\u5148\u7528 <code>-- \u6ce8\u91ca<\/code>\uff08\u901a\u7528\u6807\u51c6\uff09 <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MySQL \u4e13\u5c5e\u7b80\u5199<\/strong>\uff1a\u7528 <code># \u6ce8\u91ca<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u957f\u6587\u672c \/ \u591a\u884c \/ \u8c03\u8bd5<\/strong>\uff1a\u7528 <code>\/* \u6ce8\u91ca *\/<\/code><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>WHERE \u5b50\u53e5<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6700\u5e38\u7528\u7684\u8fd0\u7b97\u7b26<\/strong>\uff0c\u5206\u6210<strong>\u6bd4\u8f83\u8fd0\u7b97\u7b26\u3001\u8303\u56f4\u8fd0\u7b97\u7b26\u3001\u6a21\u7cca\u5339\u914d\u3001\u7a7a\u503c\u5224\u65ad\u3001\u903b\u8f91\u8fd0\u7b97\u7b26<\/strong>5 \u5927\u7c7b<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u3001\u6bd4\u8f83\u8fd0\u7b97\u7b26\uff08\u6700\u57fa\u7840\u3001\u6700\u5e38\u7528\uff09<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7528\u4e8e<strong>\u5224\u65ad\u503c\u662f\u5426\u76f8\u7b49\u3001\u5927\u5c0f\u5173\u7cfb<\/strong>\uff0c\u662f WHERE \u6700\u57fa\u7840\u7684\u7528\u6cd5\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">\u8fd0\u7b97\u7b26<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u542b\u4e49<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u793a\u4f8b<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>=<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u7b49\u4e8e<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>WHERE age = 20<\/code><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>&lt;&gt;<\/code> \/ <code>!=<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u4e0d\u7b49\u4e8e<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>WHERE age &lt;&gt; 18<\/code><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>&gt;<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5927\u4e8e<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>WHERE price &gt; 100<\/code><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>&lt;<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5c0f\u4e8e<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>WHERE score &lt; 60<\/code><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>&gt;=<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5927\u4e8e\u7b49\u4e8e<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>WHERE num &gt;= 5<\/code><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>&lt;=<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5c0f\u4e8e\u7b49\u4e8e<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>WHERE height &lt;= 180<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u5c0f\u63d0\u793a\uff1a<code>!=<\/code> \u548c <code>&lt;&gt;<\/code> \u6548\u679c\u5b8c\u5168\u4e00\u6837\uff0c<code>&lt;&gt;<\/code> \u662f SQL \u6807\u51c6\u5199\u6cd5\uff0c\u66f4\u901a\u7528\u3002<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u8303\u56f4\u8fd0\u7b97\u7b26\uff08\u5224\u65ad\u533a\u95f4\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <code>BETWEEN ... AND ...<\/code><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f5c\u7528<\/strong>\uff1a\u5339\u914d<strong>\u5728\u4e24\u4e2a\u503c\u4e4b\u95f4<\/strong>\u7684\u6570\u636e\uff08\u5305\u542b\u8d77\u59cb\u548c\u7ed3\u675f\u503c\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u5e74\u9f84\u5728 18~30 \u4e4b\u95f4\uff08\u5305\u542b18\u548c30\uff09\nWHERE age BETWEEN 18 AND 30\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. <code>NOT BETWEEN ... AND ...<\/code><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f5c\u7528<\/strong>\uff1a\u5339\u914d<strong>\u4e0d\u5728\u533a\u95f4\u5185<\/strong>\u7684\u6570\u636e<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WHERE price NOT BETWEEN 100 AND 500\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u6307\u5b9a\u96c6\u5408\u5339\u914d\uff08\u591a\u9009\u4e00\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <code>IN (\u503c1, \u503c2, ...)<\/code><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f5c\u7528<\/strong>\uff1a\u5339\u914d<strong>\u7b49\u4e8e\u5217\u8868\u4e2d\u4efb\u610f\u4e00\u4e2a\u503c<\/strong>\u7684\u6570\u636e<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u7701\u4efd\u662f\u5317\u4eac\u3001\u4e0a\u6d77\u3001\u5e7f\u5dde\u4e4b\u4e00\nWHERE city IN ('\u5317\u4eac', '\u4e0a\u6d77', '\u5e7f\u5dde')\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. <code>NOT IN (\u503c1, \u503c2, ...)<\/code><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f5c\u7528<\/strong>\uff1a\u5339\u914d<strong>\u4e0d\u5728\u5217\u8868\u4e2d<\/strong>\u7684\u6570\u636e<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WHERE status NOT IN (0, 1)\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u56db\u3001\u6a21\u7cca\u5339\u914d\uff08\u5b57\u7b26\u4e32\u641c\u7d22\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><code>LIKE<\/code> + \u901a\u914d\u7b26<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e13\u95e8\u7528\u4e8e<strong>\u6a21\u7cca\u67e5\u8be2\u6587\u672c<\/strong>\uff0c\u4e24\u4e2a\u6838\u5fc3\u901a\u914d\u7b26\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>%<\/code>\uff1a\u5339\u914d<strong>\u4efb\u610f\u591a\u4e2a\u5b57\u7b26<\/strong>\uff08\u5305\u542b 0 \u4e2a\uff09<\/li>\n\n\n\n<li><code>_<\/code>\uff1a\u5339\u914d ** exactly \u4e00\u4e2a\u5b57\u7b26 **<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">\u5199\u6cd5<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u542b\u4e49<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>LIKE '\u5f20%'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u4ee5<strong>\u5f20\u5f00\u5934<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>LIKE '%\u4e09'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u4ee5<strong>\u4e09\u7ed3\u5c3e<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>LIKE '%\u5c0f%'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5305\u542b<strong>\u5c0f<\/strong>\u5b57<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>LIKE '\u5218_'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u59d3\u5218\uff0c\u4e14<strong>\u540d\u5b57\u53ea\u6709\u4e24\u4e2a\u5b57<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u793a\u4f8b\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u67e5\u8be2\u6240\u6709\u59d3\u201c\u674e\u201d\u7684\u7528\u6237\nWHERE name LIKE '\u674e%'\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e94\u3001\u7a7a\u503c\u5224\u65ad\uff08\u7279\u522b\u91cd\u8981\uff01\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <code>IS NULL<\/code><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f5c\u7528<\/strong>\uff1a\u5224\u65ad\u5b57\u6bb5<strong>\u503c\u4e3a\u7a7a\uff08NULL\uff09<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u90ae\u7bb1\u4e3a\u7a7a\nWHERE email IS NULL\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. <code>IS NOT NULL<\/code><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f5c\u7528<\/strong>\uff1a\u5224\u65ad\u5b57\u6bb5<strong>\u4e0d\u4e3a\u7a7a<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WHERE phone IS NOT NULL\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f \u65b0\u624b\u5fc5\u5751\uff1a<strong>\u4e0d\u80fd\u7528 <code>= NULL<\/code> \u6216 <code>!= NULL<\/code><\/strong>\uff0c\u5fc5\u987b\u7528 <code>IS NULL<\/code> \/ <code>IS NOT NULL<\/code>\uff01<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u516d\u3001\u903b\u8f91\u8fd0\u7b97\u7b26\uff08\u591a\u6761\u4ef6\u7ec4\u5408\uff09<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7528\u4e8e\u628a\u591a\u4e2a\u6761\u4ef6\u7ec4\u5408\u5728\u4e00\u8d77\uff0c\u5b9e\u73b0\u590d\u6742\u7b5b\u9009\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">\u8fd0\u7b97\u7b26<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u542b\u4e49<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u793a\u4f8b<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>AND<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5e76\u4e14\uff08\u6240\u6709\u6761\u4ef6\u90fd\u6ee1\u8db3\uff09<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>age&gt;18 AND score&gt;=60<\/code><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>OR<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u6216\u8005\uff08\u4efb\u610f\u4e00\u4e2a\u6ee1\u8db3\uff09<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>city='\u5317\u4eac' OR city='\u4e0a\u6d77'<\/code><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>NOT<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u53d6\u53cd<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>NOT age&gt;30<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u793a\u4f8b\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u5e74\u9f84\u5927\u4e8e18 \u4e14 \u6027\u522b\u4e3a\u5973\nWHERE age &gt; 18 AND gender = '\u5973'<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">Mysql\u6b63\u5219\u8868\u8fbe\u5f0f<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u3001\u6838\u5fc3\u5173\u952e\u5b57\uff1aREGEXP<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL \u7528 <code>REGEXP<\/code> \u5173\u952e\u5b57\u5f00\u542f\u6b63\u5219\u5339\u914d\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u57fa\u672c\u8bed\u6cd5<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WHERE \u5b57\u6bb5\u540d REGEXP '\u6b63\u5219\u8868\u8fbe\u5f0f'\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u5bf9\u6bd4 LIKE\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>LIKE<\/code> \u4f9d\u8d56 <code>%<\/code> \u548c <code>_<\/code>\uff0c\u529f\u80fd\u5f31<\/li>\n\n\n\n<li><code>REGEXP<\/code> \u7528\u6b63\u5219\u89c4\u5219\uff0c<strong>\u590d\u6742\u6a21\u7cca\u67e5\u8be2\u9996\u9009<\/strong><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u6700\u5e38\u7528\u6b63\u5219\u8fd0\u7b97\u7b26\uff08\u5fc5\u80cc\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u57fa\u7840\u5339\u914d<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">\u5199\u6cd5<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u4f5c\u7528<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u793a\u4f8b<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>.<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d<strong>\u4efb\u610f\u4e00\u4e2a\u5b57\u7b26<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP 'b.'<\/code> \u2192 \u5339\u914d b \u540e\u9762\u8ddf\u4efb\u610f 1 \u4e2a\u5b57\u7b26<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>^<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d<strong>\u6587\u672c\u5f00\u5934<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '^\u674e'<\/code> \u2192 \u4ee5\u674e\u5f00\u5934<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>$<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d<strong>\u6587\u672c\u7ed3\u5c3e<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\u4e09$'<\/code> \u2192 \u4ee5\u4e09\u7ed3\u5c3e<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2. \u591a\u9009\u4e00\u5339\u914d<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">\u5199\u6cd5<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u4f5c\u7528<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u793a\u4f8b<\/th><th class=\"has-text-align-left\" data-align=\"left\"><\/th><th class=\"has-text-align-left\" data-align=\"left\"><\/th><th class=\"has-text-align-left\" data-align=\"left\"><\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\">`<\/td><td class=\"has-text-align-left\" data-align=\"left\">`<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u6216\uff08\u591a\u4e2a\u6761\u4ef6\u4efb\u9009\uff09<\/td><td class=\"has-text-align-left\" data-align=\"left\">`REGEXP &#8216; \u82f9\u679c<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u9999\u8549<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u6a58\u5b50 &#8216;`<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>[abc]<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d\u62ec\u53f7\u5185<strong>\u4efb\u610f\u4e00\u4e2a\u5b57\u7b26<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '[xyz]'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>[^abc]<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d<strong>\u4e0d\u5728\u62ec\u53f7\u5185<\/strong>\u7684\u5b57\u7b26<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '[^0-9]'<\/code> \u2192 \u975e\u6570\u5b57<\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3. \u8303\u56f4\u5339\u914d<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">\u5199\u6cd5<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u4f5c\u7528<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>[0-9]<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d 0~9 \u4efb\u610f\u6570\u5b57<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>[a-z]<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d\u5c0f\u5199\u5b57\u6bcd<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>[A-Z]<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d\u5927\u5199\u5b57\u6bcd<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">4. \u91cd\u590d\u5339\u914d<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">\u5199\u6cd5<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u4f5c\u7528<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>*<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">0 \u4e2a\u6216\u591a\u4e2a\uff08\u524d\u9762\u5b57\u7b26\uff09<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>+<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">1 \u4e2a\u6216\u591a\u4e2a<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>?<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">0 \u4e2a\u6216 1 \u4e2a<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>{n}<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">exactly n \u4e2a<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u5b9e\u6218\u793a\u4f8b\uff08\u4e00\u770b\u5c31\u4f1a\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u5305\u542b\u67d0\u4e2a\u6587\u672c\uff08\u6700\u7b80\u5355\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u53ea\u8981\u5b57\u6bb5\u91cc<strong>\u51fa\u73b0<\/strong>\u5185\u5bb9\u5c31\u5339\u914d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u4ea7\u54c1\u540d\u5305\u542b\u201c\u624b\u673a\u201d\nSELECT * FROM products \nWHERE prod_name REGEXP '\u624b\u673a';\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. \u4ee5\u67d0\u5b57\u7b26\u5f00\u5934 \/ \u7ed3\u5c3e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u59d3\u540d\u4ee5\u201c\u5f20\u201d\u5f00\u5934\nWHERE name REGEXP '^\u5f20';\n\n-- \u90ae\u7bb1\u4ee5 .com \u7ed3\u5c3e\nWHERE email REGEXP '\\\\.com$'; \n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f \u6ce8\u610f\uff1a<code>.<\/code> \u662f\u6b63\u5219\u5173\u952e\u5b57\uff0c\u8981\u5339\u914d\u771f\u5b9e\u7684\u70b9\uff0c\u5fc5\u987b\u52a0\u8f6c\u4e49 <code>\\\\.<\/code><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. \u591a\u6761\u4ef6 \u201c\u6216\u201d \u67e5\u8be2<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u57ce\u5e02\u662f\u5317\u4eac\u3001\u4e0a\u6d77\u3001\u5e7f\u5dde\u4e4b\u4e00\nWHERE city REGEXP '\u5317\u4eac|\u4e0a\u6d77|\u5e7f\u5dde';\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">4. \u6570\u5b57 \/ \u5b57\u6bcd\u8303\u56f4<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u624b\u673a\u53f7\u5305\u542b 13\u300115\u300118 \u5f00\u5934\nWHERE phone REGEXP '^1&#91;358]';\n\n-- \u4ea7\u54c1\u7f16\u53f7\u5305\u542b\u6570\u5b57\nWHERE prod_id REGEXP '&#91;0-9]';\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">5. \u590d\u6742\u683c\u5f0f\u5339\u914d\uff08\u8eab\u4efd\u8bc1 \/ \u90ae\u7bb1 \/ \u90ae\u7f16\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u5339\u914d 18 \u4f4d\u8eab\u4efd\u8bc1\nWHERE id_card REGEXP '^&#91;0-9]{17}&#91;0-9X]$';\n\n-- \u5339\u914d\u7eaf\u6570\u5b57\nWHERE code REGEXP '^&#91;0-9]+$';\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u56db\u3001\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff1aREGEXP \u4e0d\u533a\u5206\u5927\u5c0f\u5199<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL \u9ed8\u8ba4\u6b63\u5219<strong>\u4e0d\u533a\u5206\u5927\u5c0f\u5199<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u60f3\u4e25\u683c\u533a\u5206\uff0c\u7528 <code>BINARY<\/code> \u5173\u952e\u5b57\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WHERE name REGEXP BINARY 'Apple';\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e94\u3001LIKE \u4e0e REGEXP \u7684\u533a\u522b\uff08\u5173\u952e\uff09<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">LIKE<\/th><th class=\"has-text-align-left\" data-align=\"left\">REGEXP<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\">\u5fc5\u987b<strong>\u5b8c\u5168\u5339\u914d<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u53ea\u8981<strong>\u5305\u542b<\/strong>\u5c31\u5339\u914d<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">\u529f\u80fd\u7b80\u5355<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u529f\u80fd\u5f3a\u5927<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">\u65e0\u7279\u6b8a\u8bed\u6cd5<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u652f\u6301\u590d\u6742\u89c4\u5219<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f8b\u5b50\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WHERE name LIKE '\u4e09'   \u2192 \u53ea\u6709\u540d\u5b57=\u201c\u4e09\u201d\u624d\u5339\u914d\nWHERE name REGEXP '\u4e09' \u2192 \u540d\u5b57\u91cc**\u5305\u542b**\u4e09\u5c31\u5339\u914d\uff08\u5f20\u4e09\u3001\u674e\u56db\u4e09...\uff09<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u5339\u914d\u7279\u6b8a\u5b57\u7b26<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u3001\u4ec0\u4e48\u662f\u6b63\u5219\u7279\u6b8a\u5b57\u7b26\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728 MySQL \u6b63\u5219\u91cc\uff0c\u8fd9\u4e9b\u5b57\u7b26<strong>\u81ea\u5e26\u7279\u6b8a\u529f\u80fd<\/strong>\uff0c\u4e0d\u80fd\u76f4\u63a5\u5199\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>. * + ? | [ ] ( ) { } ^ $ \\<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u4f60\u60f3<strong>\u771f\u6b63\u5339\u914d\u8fd9\u4e9b\u7b26\u53f7\u672c\u8eab<\/strong>\uff0c\u5fc5\u987b\u52a0 <strong>\u8f6c\u4e49\u7b26<\/strong>\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>\\\\<\/code>\uff08\u4e24\u4e2a\u53cd\u659c\u6760\uff09<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u6b63\u786e\u5199\u6cd5\uff1a\u5fc5\u987b\u7528 <code>\\\\<\/code> \u8f6c\u4e49<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u6700\u5e38\u7528\u7279\u6b8a\u5b57\u7b26\u5339\u914d\uff08\u76f4\u63a5\u590d\u5236\u7528\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">\u4f60\u60f3\u5339\u914d\u7684\u5b57\u7b26<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u6b63\u5219\u91cc\u5fc5\u987b\u8fd9\u6837\u5199<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u793a\u4f8b<\/th><th class=\"has-text-align-left\" data-align=\"left\"><\/th><th class=\"has-text-align-left\" data-align=\"left\"><\/th><th class=\"has-text-align-left\" data-align=\"left\"><\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>.<\/code> \u70b9\u53f7<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>\\\\.<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\\\\.com'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>*<\/code> \u661f\u53f7<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>\\\\*<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\\\\*\u7279\u4ef7'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>+<\/code> \u52a0\u53f7<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>\\\\+<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\\\\+86'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>?<\/code> \u95ee\u53f7<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>\\\\?<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\\\\?\u67e5\u8be2'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">`<\/td><td class=\"has-text-align-left\" data-align=\"left\">` \u7ad6\u7ebf<\/td><td class=\"has-text-align-left\" data-align=\"left\">`\\<\/td><td class=\"has-text-align-left\" data-align=\"left\">`<\/td><td class=\"has-text-align-left\" data-align=\"left\">`REGEXP &#8216;\\<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5206\u9694 &#8216;`<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>[<\/code> \u5de6\u4e2d\u62ec\u53f7<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>\\\\[` | `REGEXP '\\\\[\u901a\u77e5'` | | `]` \u53f3\u4e2d\u62ec\u53f7 | `\\\\]<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\u7ed3\u675f\\\\]'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>(<\/code> \u5de6\u62ec\u53f7<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>\\\\(` | `REGEXP '\\\\(\u5907\u6ce8'` | | `)` \u53f3\u62ec\u53f7 | `\\\\)<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\u5b8c\u6210\\\\)'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>^<\/code> \u5c16\u53f7<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>\\\\^<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\\\\^\u91cd\u70b9'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>$<\/code> \u7f8e\u5143\u7b26<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>\\\\$<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\u4ef7\u683c\\\\$'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>\\<\/code> \u53cd\u659c\u6760<\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>\\\\\\\\<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><code>REGEXP '\\\\\\\\\u6587\u4ef6\u5939'<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><td class=\"has-text-align-left\" data-align=\"left\"><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u5b9e\u6218\u793a\u4f8b\uff08\u4e00\u770b\u5c31\u61c2\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u5339\u914d\u5305\u542b\u70b9\u53f7 <code>.<\/code> \u7684\u6587\u672c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u5339\u914d\u90ae\u7bb1\u3001\u7f51\u5740\u91cc\u7684 .\nSELECT * FROM user \nWHERE email REGEXP '\\\\.com';  -- \u5fc5\u987b\u5199 \\\\.\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. \u5339\u914d\u5305\u542b\u62ec\u53f7 <code>()<\/code> \u7684\u5185\u5bb9<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u5339\u914d\u5546\u54c1\u540d\u91cc\u7684 (\u7279\u4ef7)\nSELECT * FROM products \nWHERE prod_name REGEXP '\\\\(\u7279\u4ef7\\\\)';\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. \u5339\u914d\u5305\u542b\u661f\u53f7 <code>*<\/code>\u3001\u52a0\u53f7 <code>+<\/code><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u5339\u914d *\u70ed\u9500* \u3001+\u65b0\u54c1\nWHERE title REGEXP '\\\\*\u70ed\u9500\\\\*|\\\\+\u65b0\u54c1';\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">4. \u5339\u914d\u53cd\u659c\u6760 <code>\\<\/code>\uff08\u6700\u96be\u8bb0\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5339\u914d\u4e00\u4e2a <code>\\<\/code> \u5fc5\u987b\u5199 <strong>4 \u4e2a\u53cd\u659c\u6760 <code>\\\\\\\\<\/code><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u5339\u914d\u8def\u5f84\u91cc\u7684 \\\nWHERE path REGEXP '\\\\\\\\img';\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u56db\u3001\u8d85\u7ea7\u91cd\u70b9\uff1a\u4e3a\u4ec0\u4e48\u662f\u4e24\u4e2a\u53cd\u659c\u6760\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL \u91cc\u6709<strong>\u4e24\u5c42\u89e3\u6790<\/strong>\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>MySQL \u89e3\u6790\u5668\uff1a\u5904\u7406 <code>\\\\<\/code> \u2192 \u53d8\u6210 <code>\\<\/code><\/li>\n\n\n\n<li>\u6b63\u5219\u5f15\u64ce\uff1a\u5904\u7406 <code>\\<\/code> \u2192 \u8f6c\u4e49\u7279\u6b8a\u5b57\u7b26<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u6240\u4ee5\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u60f3\u5339\u914d <code>.<\/code> \u2192 \u5fc5\u987b\u5199 <code>\\\\.<\/code><\/li>\n\n\n\n<li>\u60f3\u5339\u914d <code>\\<\/code> \u2192 \u5fc5\u987b\u5199 <code>\\\\\\\\<\/code><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e94\u3001\u907f\u5751\u603b\u7ed3<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u53ea\u8981\u5339\u914d\u7279\u6b8a\u5b57\u7b26\uff0c\u524d\u9762\u5fc5\u987b\u52a0 <code>\\\\<\/code><\/strong><\/li>\n\n\n\n<li>\u76f4\u63a5\u5199 <code>. = * + ? | [ ]<\/code> \u4e00\u5b9a\u4f1a<strong>\u5339\u914d\u9519\u8bef\u6216\u62a5\u9519<\/strong><\/li>\n\n\n\n<li>\u53cd\u659c\u6760 <code>\\<\/code> \u6700\u7279\u6b8a\uff0c\u5fc5\u987b\u5199 <code>\\\\\\\\<\/code><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">12 \u4e2a POSIX \u6b63\u5219\u5b57\u7b26\u7c7b<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>[:alnum:]<\/code> \u5b57\u6bcd\u6570\u5b57<\/li>\n\n\n\n<li><code>[:alpha:]<\/code> \u7eaf\u5b57\u6bcd<\/li>\n\n\n\n<li><code>[:blank:]<\/code> \u7a7a\u683c\u3001\u5236\u8868\u7b26<\/li>\n\n\n\n<li><code>[:cntrl:]<\/code> \u63a7\u5236\u5b57\u7b26<\/li>\n\n\n\n<li><code>[:digit:]<\/code> \u6570\u5b57 0-9<\/li>\n\n\n\n<li><code>[:graph:]<\/code> \u53ef\u89c1\u975e\u7a7a\u767d\u5b57\u7b26<\/li>\n\n\n\n<li><code>[:lower:]<\/code> \u5c0f\u5199\u5b57\u6bcd<\/li>\n\n\n\n<li><code>[:upper:]<\/code> \u5927\u5199\u5b57\u6bcd<\/li>\n\n\n\n<li><code>[:print:]<\/code> \u53ef\u6253\u5370\u5b57\u7b26<\/li>\n\n\n\n<li><code>[:punct:]<\/code> \u6807\u70b9\u7b26\u53f7<\/li>\n\n\n\n<li><code>[:space:]<\/code> \u6240\u6709\u7a7a\u767d\uff08\u7a7a\u683c\u3001\u6362\u884c\u3001\u5236\u8868\uff09<\/li>\n\n\n\n<li><code>[:xdigit:]<\/code> \u5341\u516d\u8fdb\u5236\u5b57\u7b26 0-9 a-f A-F<\/li>\n<\/ol>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL \u6b63\u5219 \u91cd\u590d\u5143\u5b57\u7b26<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u8868\u683c<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">\u5143\u5b57\u7b26<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u542b\u4e49<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>*<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d\u524d\u9762\u5b57\u7b26 <strong>0 \u6b21\u6216\u591a\u6b21<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>+<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d\u524d\u9762\u5b57\u7b26 <strong>1 \u6b21\u6216\u591a\u6b21<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>?<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d\u524d\u9762\u5b57\u7b26 <strong>0 \u6b21\u6216 1 \u6b21<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>{n}<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u7cbe\u786e\u5339\u914d <strong>n \u6b21<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>{n,}<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d <strong>\u81f3\u5c11 n \u6b21<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><code>{n,m}<\/code><\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5339\u914d <strong>n \u5230 m \u6b21<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u7528\u6cd5\u793a\u4f8b\uff1a<code>a{3}<\/code> \u5339\u914d\u8fde\u7eed 3 \u4e2a a\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL \u6b63\u5219 \u5b9a\u4f4d\u7b26<\/h1>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>^<\/strong> \u5339\u914d<strong>\u5b57\u7b26\u4e32\u5f00\u5934<\/strong><\/li>\n\n\n\n<li><strong>$<\/strong> \u5339\u914d<strong>\u5b57\u7b26\u4e32\u7ed3\u5c3e<\/strong><\/li>\n\n\n\n<li><strong>[[:&lt;:]]<\/strong> \u5355\u8bcd<strong>\u5f00\u5934<\/strong><\/li>\n\n\n\n<li><strong>[[:>:]]<\/strong> \u5355\u8bcd<strong>\u7ed3\u5c3e<\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u793a\u4f8b\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>^a<\/code> \u4ee5 a \u5f00\u5934\uff1b<code>z$<\/code> \u4ee5 z \u7ed3\u5c3e\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL \u8ba1\u7b97\u5b57\u6bb5<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">1. \u6982\u5ff5<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u8ba1\u7b97\u5b57\u6bb5<\/strong>\uff1a\u6570\u636e\u5e93\u4e2d\u4e0d\u5b58\u5728\uff0c\u67e5\u8be2\u65f6<strong>\u4e34\u65f6\u62fc\u63a5\u3001\u8fd0\u7b97\u751f\u6210<\/strong>\u7684\u5b57\u6bb5\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. \u5e38\u7528\u573a\u666f<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u62fc\u63a5\u5b57\u7b26\u4e32<\/li>\n\n\n\n<li>\u6570\u503c\u56db\u5219\u8fd0\u7b97<\/li>\n\n\n\n<li>\u8d77\u522b\u540d <code>AS<\/code><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">3. \u6838\u5fc3\u8bed\u6cd5<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u62fc\u63a5\nSELECT CONCAT(\u5b57\u6bb51,\u5b57\u6bb52) AS \u65b0\u5b57\u6bb5\u540d;\n\n-- \u8ba1\u7b97\nSELECT \u5b57\u6bb51 * \u5b57\u6bb52 AS \u65b0\u5b57\u6bb5\u540d;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">4. \u5e38\u7528\u64cd\u4f5c<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u62fc\u63a5<\/strong>\uff1a<code>CONCAT()<\/code> \u5408\u5e76\u591a\u4e2a\u5b57\u6bb5<\/li>\n\n\n\n<li><strong>\u7b97\u672f\u8fd0\u7b97<\/strong>\uff1a<code>+ - * \/<\/code><\/li>\n\n\n\n<li><strong>\u522b\u540d<\/strong>\uff1a<code>AS<\/code> \u7ed9\u8ba1\u7b97\u5b57\u6bb5\u8d77\u540d\uff0c\u53ef\u7701\u7565 AS<\/li>\n\n\n\n<li>\u8ba1\u7b97\u5b57\u6bb5<strong>\u53ea\u5728\u67e5\u8be2\u7ed3\u679c\u751f\u6548\uff0c\u4e0d\u6539\u53d8\u539f\u8868<\/strong><\/li>\n<\/ol>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL \u53bb\u7a7a\u683c\u51fd\u6570<\/h1>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>LTRIM()<\/strong> \u53bb\u6389<strong>\u5de6\u4fa7<\/strong>\u7a7a\u683c<\/li>\n\n\n\n<li><strong>RTRIM()<\/strong> \u53bb\u6389<strong>\u53f3\u4fa7<\/strong>\u7a7a\u683c<\/li>\n\n\n\n<li><strong>TRIM()<\/strong> \u53bb\u6389<strong>\u5de6\u53f3\u4e24\u7aef<\/strong>\u7a7a\u683c<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u8bed\u6cd5\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT TRIM(\u5b57\u6bb5) FROM \u8868;\nSELECT LTRIM(\u5b57\u6bb5), RTRIM(\u5b57\u6bb5) FROM \u8868;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6269\u5c55\uff1a<code>TRIM(\u5b57\u7b26 FROM \u5b57\u6bb5)<\/code> \u53ef\u53bb\u9664\u6307\u5b9a\u9996\u5c3e\u5b57\u7b26\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL \u51fd\u6570<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u3001\u5b57\u7b26\u4e32\u51fd\u6570<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>CONCAT()<\/code> \u62fc\u63a5\u5b57\u7b26\u4e32<\/li>\n\n\n\n<li><code>CONCAT_WS()<\/code> \u5e26\u5206\u9694\u7b26\u62fc\u63a5<\/li>\n\n\n\n<li><code>LTRIM()<\/code> \u53bb\u9664\u5de6\u4fa7\u7a7a\u683c<\/li>\n\n\n\n<li><code>RTRIM()<\/code> \u53bb\u9664\u53f3\u4fa7\u7a7a\u683c<\/li>\n\n\n\n<li><code>TRIM()<\/code> \u53bb\u9664\u4e24\u7aef\u7a7a\u683c<\/li>\n\n\n\n<li><code>UPPER()\/UCASE()<\/code> \u8f6c\u5927\u5199<\/li>\n\n\n\n<li><code>LOWER()\/LCASE()<\/code> \u8f6c\u5c0f\u5199<\/li>\n\n\n\n<li><code>LEFT()<\/code> \u5de6\u622a\u53d6<\/li>\n\n\n\n<li><code>RIGHT()<\/code> \u53f3\u622a\u53d6<\/li>\n\n\n\n<li><code>SUBSTRING()<\/code> \u622a\u53d6\u5b50\u4e32<\/li>\n\n\n\n<li><code>LENGTH()<\/code> \u5b57\u8282\u957f\u5ea6<\/li>\n\n\n\n<li><code>CHAR_LENGTH()<\/code> \u5b57\u7b26\u957f\u5ea6<\/li>\n\n\n\n<li><code>REPLACE()<\/code> \u66ff\u6362<\/li>\n\n\n\n<li><code>LOCATE()<\/code> \u67e5\u627e\u4f4d\u7f6e<\/li>\n\n\n\n<li><code>REVERSE()<\/code> \u53cd\u8f6c<\/li>\n\n\n\n<li><code>REPEAT()<\/code> \u91cd\u590d\u5b57\u7b26\u4e32<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u6570\u503c \/ \u6570\u5b66\u51fd\u6570<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>ABS()<\/code> \u7edd\u5bf9\u503c<\/li>\n\n\n\n<li><code>MOD()<\/code> \u53d6\u6a21 \/ \u4f59\u6570<\/li>\n\n\n\n<li><code>ROUND()<\/code> \u56db\u820d\u4e94\u5165<\/li>\n\n\n\n<li><code>CEIL()\/CEILING()<\/code> \u5411\u4e0a\u53d6\u6574<\/li>\n\n\n\n<li><code>FLOOR()<\/code> \u5411\u4e0b\u53d6\u6574<\/li>\n\n\n\n<li><code>RAND()<\/code> 0~1 \u968f\u673a\u6570<\/li>\n\n\n\n<li><code>PI()<\/code> \u5706\u5468\u7387 \u03c0<\/li>\n\n\n\n<li><code>SQRT()<\/code> \u5e73\u65b9\u6839<\/li>\n\n\n\n<li><code>POW()\/POWER()<\/code> \u5e42\u8fd0\u7b97<\/li>\n\n\n\n<li><code>EXP()<\/code> e \u7684 x \u6b21\u65b9<\/li>\n\n\n\n<li><code>LOG()<\/code> \u81ea\u7136\u5bf9\u6570<\/li>\n\n\n\n<li><code>LOG10()<\/code> \u4ee5 10 \u4e3a\u5e95\u5bf9\u6570<\/li>\n\n\n\n<li><code>SIN()<\/code> \u6b63\u5f26<\/li>\n\n\n\n<li><code>COS()<\/code> \u4f59\u5f26<\/li>\n\n\n\n<li><code>TAN()<\/code> \u6b63\u5207<\/li>\n\n\n\n<li><code>ASIN()<\/code> \u53cd\u6b63\u5f26<\/li>\n\n\n\n<li><code>ACOS()<\/code> \u53cd\u4f59\u5f26<\/li>\n\n\n\n<li><code>ATAN()<\/code> \u53cd\u6b63\u5207<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u65e5\u671f\u65f6\u95f4\u51fd\u6570<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>NOW()<\/code> \u5f53\u524d\u65e5\u671f\u65f6\u95f4<\/li>\n\n\n\n<li><code>CURDATE()<\/code> \u5f53\u524d\u65e5\u671f<\/li>\n\n\n\n<li><code>CURTIME()<\/code> \u5f53\u524d\u65f6\u95f4<\/li>\n\n\n\n<li><code>DATE()<\/code> \u63d0\u53d6\u65e5\u671f<\/li>\n\n\n\n<li><code>TIME()<\/code> \u63d0\u53d6\u65f6\u95f4<\/li>\n\n\n\n<li><code>YEAR()\/MONTH()\/DAY()<\/code> \u5e74\u6708\u65e5<\/li>\n\n\n\n<li><code>HOUR()\/MINUTE()\/SECOND()<\/code> \u65f6\u5206\u79d2<\/li>\n\n\n\n<li><code>DATE_ADD()<\/code> \u589e\u52a0\u65f6\u95f4<\/li>\n\n\n\n<li><code>ADDDATE()<\/code> \u589e\u52a0\u65e5\u671f<\/li>\n\n\n\n<li><code>DATE_SUB()<\/code> \u51cf\u5c11\u65e5\u671f<\/li>\n\n\n\n<li><code>ADDTIME()<\/code> \u589e\u52a0\u65f6\u95f4<\/li>\n\n\n\n<li><code>DATEDIFF()<\/code> \u65e5\u671f\u5dee<\/li>\n\n\n\n<li><code>TIMEDIFF()<\/code> \u65f6\u95f4\u5dee<\/li>\n\n\n\n<li><code>DAYOFWEEK()<\/code> \u5468\u51e0<\/li>\n\n\n\n<li><code>DAYOFMONTH()<\/code> \u5f53\u6708\u7b2c\u51e0\u5929<\/li>\n\n\n\n<li><code>DAYOFYEAR()<\/code> \u5f53\u5e74\u7b2c\u51e0\u5929<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u56db\u3001\u805a\u5408\u51fd\u6570<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>COUNT()<\/code> \u8ba1\u6570<\/li>\n\n\n\n<li><code>SUM()<\/code> \u6c42\u548c<\/li>\n\n\n\n<li><code>AVG()<\/code> \u5e73\u5747\u503c<\/li>\n\n\n\n<li><code>MAX()<\/code> \u6700\u5927\u503c<\/li>\n\n\n\n<li><code>MIN()<\/code> \u6700\u5c0f\u503c<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e94\u3001\u6761\u4ef6 \/ \u6d41\u7a0b\u51fd\u6570<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>IF()<\/code> \u6761\u4ef6\u5224\u65ad<\/li>\n\n\n\n<li><code>IFNULL()<\/code> \u7a7a\u503c\u66ff\u6362<\/li>\n\n\n\n<li><code>NULLIF()<\/code> \u76f8\u7b49\u8fd4\u56de NULL<\/li>\n\n\n\n<li><code>CASE WHEN<\/code> \u591a\u5206\u652f\u5224\u65ad<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u516d\u3001\u6587\u672c\u5904\u7406\u51fd\u6570<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>TRIM()<\/code><\/li>\n\n\n\n<li><code>UPPER()<\/code><\/li>\n\n\n\n<li><code>LOWER()<\/code><\/li>\n\n\n\n<li><code>LENGTH()<\/code><\/li>\n<\/ol>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL \u805a\u5408\u51fd\u6570 + \u7ec4\u5408\u7528\u6cd5<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u30015 \u5927\u57fa\u7840\u805a\u5408\u51fd\u6570<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>COUNT()<\/code> \u7edf\u8ba1\u884c\u6570 \/ \u975e\u7a7a\u503c<\/li>\n\n\n\n<li><code>SUM()<\/code> \u6c42\u548c<\/li>\n\n\n\n<li><code>AVG()<\/code> \u5e73\u5747\u503c<\/li>\n\n\n\n<li><code>MAX()<\/code> \u6700\u5927\u503c<\/li>\n\n\n\n<li><code>MIN()<\/code> \u6700\u5c0f\u503c<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u57fa\u7840\u8bed\u6cd5<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \u805a\u5408\u51fd\u6570(\u5b57\u6bb5) FROM \u8868\u540d;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u7ec4\u5408\u7528\u6cd5\u6838\u5fc3<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u540c\u53e5\u591a\u4e2a\u805a\u5408\u4e00\u8d77\u7528<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \nCOUNT(*) AS \u603b\u6570\u91cf,\nSUM(price) AS \u603b\u4ef7,\nAVG(price) AS \u5747\u4ef7,\nMAX(price) AS \u6700\u9ad8\u4ef7,\nMIN(price) AS \u6700\u4f4e\u4ef7\nFROM products;\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. \u642d\u914d WHERE \u5148\u7b5b\u9009\u518d\u805a\u5408<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT COUNT(*),SUM(price)\nFROM products\nWHERE price &gt; 50;\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. GROUP BY \u5206\u7ec4\u805a\u5408\uff08\u6700\u5e38\u7528\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u89c4\u5219<\/strong>\uff1a<code>GROUP BY<\/code> \u5206\u7ec4\u5b57\u6bb5\uff0cSELECT \u91cc\u975e\u805a\u5408\u5b57\u6bb5\u5fc5\u987b\u51fa\u73b0\u5728 GROUP BY \u4e2d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT category,COUNT(*),AVG(price)\nFROM products\nGROUP BY category;\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">4. HAVING \u8fc7\u6ee4\u5206\u7ec4\u7ed3\u679c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">WHERE \u8fc7\u6ee4\u884c\uff0cHAVING \u8fc7\u6ee4<strong>\u5206\u7ec4\u540e<\/strong>\u7684\u6570\u636e<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT category,COUNT(*) AS cnt\nFROM products\nGROUP BY category\nHAVING cnt &gt;= 3;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u56db\u3001\u5173\u952e\u533a\u522b<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>WHERE<\/code>\uff1a\u5206\u7ec4<strong>\u524d<\/strong>\u7b5b\u9009\u539f\u59cb\u884c<\/li>\n\n\n\n<li><code>GROUP BY<\/code>\uff1a\u6309\u5b57\u6bb5\u5206\u7ec4<\/li>\n\n\n\n<li><code>HAVING<\/code>\uff1a\u5206\u7ec4<strong>\u540e<\/strong>\u7b5b\u9009\u805a\u5408\u7ed3\u679c<\/li>\n\n\n\n<li>\u805a\u5408\u51fd\u6570<strong>\u4e0d\u80fd\u7528\u5728 WHERE<\/strong>\uff0c\u53ea\u80fd\u7528\u5728 SELECT\u3001HAVING\u3001ORDER BY<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\uff0c\u4e0b\u8f7dMySQL \u8fd9\u662f\u4e0b\u8f7d\u5730\u5740\uff1ahttps:\/\/dev.mysql.com\/downloads\/mysql  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-852","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL\u6570\u636e\u5e93 - Hueil\u306e\u5c0f\u7a9d<\/title>\n<meta name=\"description\" content=\"\u8ba1\u7b97\u673a\u5e94\u7528\uff0cPython\uff0cJava\uff0c\u4fe1\u606f\u5b89\u5168\uff0c\u7f51\u7ad9\u7f8e\u5316,\u7269\u8054\u7f51\uff0cC\/C++\u7b97\u6cd5\u5206\u6790,\u7f51\u7ad9\u5b9e\u6218\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hueil.top\/?p=852\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL\u6570\u636e\u5e93 - Hueil\u306e\u5c0f\u7a9d\" \/>\n<meta property=\"og:description\" content=\"\u8ba1\u7b97\u673a\u5e94\u7528\uff0cPython\uff0cJava\uff0c\u4fe1\u606f\u5b89\u5168\uff0c\u7f51\u7ad9\u7f8e\u5316,\u7269\u8054\u7f51\uff0cC\/C++\u7b97\u6cd5\u5206\u6790,\u7f51\u7ad9\u5b9e\u6218\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hueil.top\/?p=852\" \/>\n<meta property=\"og:site_name\" content=\"Hueil\u306e\u5c0f\u7a9d\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-19T13:39:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-04T09:04:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1439\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"\u5c0f\u5f20\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5c0f\u5f20\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hueil.top\/?p=852#article\",\"isPartOf\":{\"@id\":\"https:\/\/hueil.top\/?p=852\"},\"author\":{\"name\":\"\u5c0f\u5f20\",\"@id\":\"https:\/\/hueil.top\/#\/schema\/person\/b3ed2232564570b957865ad1cefe7b88\"},\"headline\":\"MySQL\u6570\u636e\u5e93\",\"datePublished\":\"2025-10-19T13:39:56+00:00\",\"dateModified\":\"2026-05-04T09:04:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hueil.top\/?p=852\"},\"wordCount\":231,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hueil.top\/#\/schema\/person\/b3ed2232564570b957865ad1cefe7b88\"},\"image\":{\"@id\":\"https:\/\/hueil.top\/?p=852#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp\",\"articleSection\":[\"MySQL\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hueil.top\/?p=852#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hueil.top\/?p=852\",\"url\":\"https:\/\/hueil.top\/?p=852\",\"name\":\"MySQL\u6570\u636e\u5e93 - Hueil\u306e\u5c0f\u7a9d\",\"isPartOf\":{\"@id\":\"https:\/\/hueil.top\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hueil.top\/?p=852#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hueil.top\/?p=852#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp\",\"datePublished\":\"2025-10-19T13:39:56+00:00\",\"dateModified\":\"2026-05-04T09:04:12+00:00\",\"description\":\"\u8ba1\u7b97\u673a\u5e94\u7528\uff0cPython\uff0cJava\uff0c\u4fe1\u606f\u5b89\u5168\uff0c\u7f51\u7ad9\u7f8e\u5316,\u7269\u8054\u7f51\uff0cC\/C++\u7b97\u6cd5\u5206\u6790,\u7f51\u7ad9\u5b9e\u6218\",\"breadcrumb\":{\"@id\":\"https:\/\/hueil.top\/?p=852#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hueil.top\/?p=852\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/hueil.top\/?p=852#primaryimage\",\"url\":\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp\",\"contentUrl\":\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp\",\"width\":2560,\"height\":1439},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hueil.top\/?p=852#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/hueil.top\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL\u6570\u636e\u5e93\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hueil.top\/#website\",\"url\":\"https:\/\/hueil.top\/\",\"name\":\"Hueil\u306e\u5c0f\u7a9d\",\"description\":\"Hueil\u7684\u5c0f\u7834\u7ad9\",\"publisher\":{\"@id\":\"https:\/\/hueil.top\/#\/schema\/person\/b3ed2232564570b957865ad1cefe7b88\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hueil.top\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/hueil.top\/#\/schema\/person\/b3ed2232564570b957865ad1cefe7b88\",\"name\":\"\u5c0f\u5f20\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/hueil.top\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/08\/Hueil.jpg\",\"contentUrl\":\"https:\/\/hueil.top\/wp-content\/uploads\/2025\/08\/Hueil.jpg\",\"width\":940,\"height\":940,\"caption\":\"\u5c0f\u5f20\"},\"logo\":{\"@id\":\"https:\/\/hueil.top\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/hueil.top\"],\"url\":\"https:\/\/hueil.top\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL\u6570\u636e\u5e93 - Hueil\u306e\u5c0f\u7a9d","description":"\u8ba1\u7b97\u673a\u5e94\u7528\uff0cPython\uff0cJava\uff0c\u4fe1\u606f\u5b89\u5168\uff0c\u7f51\u7ad9\u7f8e\u5316,\u7269\u8054\u7f51\uff0cC\/C++\u7b97\u6cd5\u5206\u6790,\u7f51\u7ad9\u5b9e\u6218","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hueil.top\/?p=852","og_locale":"zh_CN","og_type":"article","og_title":"MySQL\u6570\u636e\u5e93 - Hueil\u306e\u5c0f\u7a9d","og_description":"\u8ba1\u7b97\u673a\u5e94\u7528\uff0cPython\uff0cJava\uff0c\u4fe1\u606f\u5b89\u5168\uff0c\u7f51\u7ad9\u7f8e\u5316,\u7269\u8054\u7f51\uff0cC\/C++\u7b97\u6cd5\u5206\u6790,\u7f51\u7ad9\u5b9e\u6218","og_url":"https:\/\/hueil.top\/?p=852","og_site_name":"Hueil\u306e\u5c0f\u7a9d","article_published_time":"2025-10-19T13:39:56+00:00","article_modified_time":"2026-05-04T09:04:12+00:00","og_image":[{"width":2560,"height":1439,"url":"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp","type":"image\/webp"}],"author":"\u5c0f\u5f20","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u5c0f\u5f20","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hueil.top\/?p=852#article","isPartOf":{"@id":"https:\/\/hueil.top\/?p=852"},"author":{"name":"\u5c0f\u5f20","@id":"https:\/\/hueil.top\/#\/schema\/person\/b3ed2232564570b957865ad1cefe7b88"},"headline":"MySQL\u6570\u636e\u5e93","datePublished":"2025-10-19T13:39:56+00:00","dateModified":"2026-05-04T09:04:12+00:00","mainEntityOfPage":{"@id":"https:\/\/hueil.top\/?p=852"},"wordCount":231,"commentCount":0,"publisher":{"@id":"https:\/\/hueil.top\/#\/schema\/person\/b3ed2232564570b957865ad1cefe7b88"},"image":{"@id":"https:\/\/hueil.top\/?p=852#primaryimage"},"thumbnailUrl":"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp","articleSection":["MySQL"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hueil.top\/?p=852#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hueil.top\/?p=852","url":"https:\/\/hueil.top\/?p=852","name":"MySQL\u6570\u636e\u5e93 - Hueil\u306e\u5c0f\u7a9d","isPartOf":{"@id":"https:\/\/hueil.top\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hueil.top\/?p=852#primaryimage"},"image":{"@id":"https:\/\/hueil.top\/?p=852#primaryimage"},"thumbnailUrl":"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp","datePublished":"2025-10-19T13:39:56+00:00","dateModified":"2026-05-04T09:04:12+00:00","description":"\u8ba1\u7b97\u673a\u5e94\u7528\uff0cPython\uff0cJava\uff0c\u4fe1\u606f\u5b89\u5168\uff0c\u7f51\u7ad9\u7f8e\u5316,\u7269\u8054\u7f51\uff0cC\/C++\u7b97\u6cd5\u5206\u6790,\u7f51\u7ad9\u5b9e\u6218","breadcrumb":{"@id":"https:\/\/hueil.top\/?p=852#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hueil.top\/?p=852"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/hueil.top\/?p=852#primaryimage","url":"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp","contentUrl":"https:\/\/hueil.top\/wp-content\/uploads\/2025\/10\/MySQL-scaled.webp","width":2560,"height":1439},{"@type":"BreadcrumbList","@id":"https:\/\/hueil.top\/?p=852#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/hueil.top\/"},{"@type":"ListItem","position":2,"name":"MySQL\u6570\u636e\u5e93"}]},{"@type":"WebSite","@id":"https:\/\/hueil.top\/#website","url":"https:\/\/hueil.top\/","name":"Hueil\u306e\u5c0f\u7a9d","description":"Hueil\u7684\u5c0f\u7834\u7ad9","publisher":{"@id":"https:\/\/hueil.top\/#\/schema\/person\/b3ed2232564570b957865ad1cefe7b88"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hueil.top\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/hueil.top\/#\/schema\/person\/b3ed2232564570b957865ad1cefe7b88","name":"\u5c0f\u5f20","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/hueil.top\/#\/schema\/person\/image\/","url":"https:\/\/hueil.top\/wp-content\/uploads\/2025\/08\/Hueil.jpg","contentUrl":"https:\/\/hueil.top\/wp-content\/uploads\/2025\/08\/Hueil.jpg","width":940,"height":940,"caption":"\u5c0f\u5f20"},"logo":{"@id":"https:\/\/hueil.top\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/hueil.top"],"url":"https:\/\/hueil.top\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/hueil.top\/index.php?rest_route=\/wp\/v2\/posts\/852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hueil.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hueil.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hueil.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hueil.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=852"}],"version-history":[{"count":30,"href":"https:\/\/hueil.top\/index.php?rest_route=\/wp\/v2\/posts\/852\/revisions"}],"predecessor-version":[{"id":2182,"href":"https:\/\/hueil.top\/index.php?rest_route=\/wp\/v2\/posts\/852\/revisions\/2182"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hueil.top\/index.php?rest_route=\/wp\/v2\/media\/858"}],"wp:attachment":[{"href":"https:\/\/hueil.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hueil.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hueil.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}