{"id":106819,"date":"2026-09-18T11:32:39","date_gmt":"2026-09-18T03:32:39","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/106819.html"},"modified":"2026-09-18T11:32:39","modified_gmt":"2026-09-18T03:32:39","slug":"mysql-%e5%9f%ba%e6%9c%ac%e6%9f%a5%e8%af%a2%ef%bc%886%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/106819.html","title":{"rendered":"MySQL \u57fa\u672c\u67e5\u8be2\uff086\uff09"},"content":{"rendered":"<\/p>\n<h4>\u76ee\u5f55<\/h4>\n<ul>\n<li>\n<ul>\n<li>1. CRUD \u6982\u8ff0<\/li>\n<li>2. Create&#xff1a;\u63d2\u5165\u6570\u636e<\/li>\n<li>\n<ul>\n<li>2.1 \u521b\u5efa\u5b66\u751f\u8868<\/li>\n<li>2.2 \u5355\u884c &#043; \u5168\u5217\u63d2\u5165<\/li>\n<li>2.3 \u591a\u884c &#043; \u6307\u5b9a\u5217\u63d2\u5165<\/li>\n<li>2.4 \u63d2\u5165\u5426\u5219\u66f4\u65b0&#xff1a;ON DUPLICATE KEY UPDATE<\/li>\n<li>2.5 \u66ff\u6362&#xff1a;REPLACE<\/li>\n<\/ul>\n<\/li>\n<li>3. Retrieve&#xff1a;\u67e5\u8be2\u6570\u636e<\/li>\n<li>\n<ul>\n<li>3.1 \u51c6\u5907\u8003\u8bd5\u6210\u7ee9\u8868<\/li>\n<li>3.2 SELECT \u5217<\/li>\n<li>\n<ul>\n<li>3.2.1 \u5168\u5217\u67e5\u8be2<\/li>\n<li>3.2.2 \u6307\u5b9a\u5217\u67e5\u8be2<\/li>\n<li>3.2.3 \u67e5\u8be2\u5b57\u6bb5\u4e3a\u8868\u8fbe\u5f0f<\/li>\n<li>3.2.4 \u4e3a\u67e5\u8be2\u7ed3\u679c\u6307\u5b9a\u522b\u540d<\/li>\n<li>3.2.5 \u7ed3\u679c\u53bb\u91cd<\/li>\n<\/ul>\n<\/li>\n<li>3.3 WHERE \u6761\u4ef6<\/li>\n<li>3.4 ORDER BY \u6392\u5e8f<\/li>\n<li>3.5 LIMIT \u5206\u9875<\/li>\n<\/ul>\n<\/li>\n<li>4. Update&#xff1a;\u66f4\u65b0\u6570\u636e<\/li>\n<li>5. Delete&#xff1a;\u5220\u9664\u6570\u636e<\/li>\n<li>6. \u63d2\u5165\u67e5\u8be2\u7ed3\u679c\u4e0e\u53bb\u91cd<\/li>\n<li>7. \u805a\u5408\u51fd\u6570<\/li>\n<li>8. GROUP BY \u4e0e HAVING<\/li>\n<li>9. \u5b9e\u6218 OJ \u4e0e\u6267\u884c\u987a\u5e8f<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u5728 MySQL \u4e2d&#xff0c;\u589e\u5220\u6539\u67e5&#xff08;CRUD&#xff09;\u662f\u6570\u636e\u5e93\u64cd\u4f5c\u7684\u6838\u5fc3\u3002\u672c\u6587\u4ece\u5b9e\u6218\u89d2\u5ea6\u51fa\u53d1&#xff0c;\u5e26\u4f60\u7cfb\u7edf\u638c\u63e1 INSERT\u3001SELECT\u3001UPDATE\u3001DELETE \u7b49\u57fa\u672c\u67e5\u8be2&#xff0c;\u914d\u5408\u5927\u91cf\u6848\u4f8b\u4e0e\u6267\u884c\u7ed3\u679c&#xff0c;\u8ba9\u4f60\u7684\u6570\u636e\u64cd\u4f5c\u575a\u5982\u78d0\u77f3&#xff01;<\/p>\n<hr \/>\n<h3>1. CRUD \u6982\u8ff0<\/h3>\n<p>CRUD \u6307\u6570\u636e\u5e93\u4e2d\u6700\u57fa\u7840\u7684\u56db\u79cd\u64cd\u4f5c&#xff1a;<\/p>\n<table>\n<tr>\u64cd\u4f5c\u542b\u4e49SQL<\/tr>\n<tbody>\n<tr>\n<td>Create<\/td>\n<td>\u521b\u5efa\/\u63d2\u5165<\/td>\n<td>INSERT<\/td>\n<\/tr>\n<tr>\n<td>Retrieve<\/td>\n<td>\u67e5\u8be2<\/td>\n<td>SELECT<\/td>\n<\/tr>\n<tr>\n<td>Update<\/td>\n<td>\u66f4\u65b0<\/td>\n<td>UPDATE<\/td>\n<\/tr>\n<tr>\n<td>Delete<\/td>\n<td>\u5220\u9664<\/td>\n<td>DELETE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u4e0b\u9762\u4ee5\u5b66\u751f\u8868\u548c\u8003\u8bd5\u6210\u7ee9\u8868\u4e3a\u4f8b&#xff0c;\u9010\u6b65\u5c55\u5f00\u3002<\/p>\n<hr \/>\n<h3>2. Create&#xff1a;\u63d2\u5165\u6570\u636e<\/h3>\n<h4>2.1 \u521b\u5efa\u5b66\u751f\u8868<\/h4>\n<p><span class=\"token keyword\">create<\/span> <span class=\"token keyword\">table<\/span> students <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">int<\/span> <span class=\"token keyword\">unsigned<\/span> <span class=\"token keyword\">primary<\/span> <span class=\"token keyword\">key<\/span> <span class=\"token keyword\">auto_increment<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    sn <span class=\"token keyword\">int<\/span> <span class=\"token operator\">not<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token keyword\">unique<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">&#039;\u5b66\u53f7&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    name <span class=\"token keyword\">varchar<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">20<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">not<\/span> <span class=\"token boolean\">null<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    qq <span class=\"token keyword\">varchar<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">20<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>2.2 \u5355\u884c &#043; \u5168\u5217\u63d2\u5165<\/h4>\n<p>\u63d2\u5165\u65f6 values \u7684\u6570\u91cf\u5fc5\u987b\u4e0e\u8868\u4e2d\u5217\u7684\u6570\u91cf\u3001\u987a\u5e8f\u4e00\u81f4\u3002<\/p>\n<p><span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> students <span class=\"token keyword\">values<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">10000<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u5510\u4e09\u85cf&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">null<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> students <span class=\"token keyword\">values<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">101<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">10001<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u5b59\u609f\u7a7a&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;11111&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u67e5\u770b\u63d2\u5165\u7ed3\u679c&#xff1a;<\/p>\n<p><span class=\"token keyword\">select<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">from<\/span> students<span class=\"token punctuation\">;<\/span><\/p>\n<p>&#043;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;&#8212;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;<br \/>\n| id  | sn    | name   | qq    |<br \/>\n&#043;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;&#8212;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;<br \/>\n| 100 | 10000 | \u5510\u4e09\u85cf | NULL  |<br \/>\n| 101 | 10001 | \u5b59\u609f\u7a7a | 11111 |<br \/>\n&#043;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;&#8212;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;<br \/>\n2 rows in set (0.00 sec)<\/p>\n<p>\u5982\u679c id \u662f\u81ea\u589e\u4e3b\u952e&#xff0c;\u4e5f\u53ef\u4ee5\u4e0d\u6307\u5b9a id&#xff0c;\u4f46\u9700\u8981\u660e\u786e\u63d2\u5165\u54ea\u4e9b\u5217&#xff1a;<\/p>\n<p><span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> students <span class=\"token punctuation\">(<\/span>sn<span class=\"token punctuation\">,<\/span> name<span class=\"token punctuation\">,<\/span> qq<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">values<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">10002<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u732a\u609f\u80fd&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">null<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>2.3 \u591a\u884c &#043; \u6307\u5b9a\u5217\u63d2\u5165<\/h4>\n<p><span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> students <span class=\"token punctuation\">(<\/span>sn<span class=\"token punctuation\">,<\/span> name<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">values<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token number\">20001<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u66f9\u5b5f\u5fb7&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token number\">20002<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u5b59\u4ef2\u8c0b&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u67e5\u770b\u7ed3\u679c&#xff1a;<\/p>\n<p><span class=\"token keyword\">select<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">from<\/span> students<span class=\"token punctuation\">;<\/span><\/p>\n<p>&#043;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;&#8212;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;<br \/>\n| id  | sn    | name   | qq    |<br \/>\n&#043;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;&#8212;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;<br \/>\n| 100 | 10000 | \u5510\u4e09\u85cf | NULL  |<br \/>\n| 101 | 10001 | \u5b59\u609f\u7a7a | 11111 |<br \/>\n| 102 | 20001 | \u66f9\u5b5f\u5fb7 | NULL  |<br \/>\n| 103 | 20002 | \u5b59\u4ef2\u8c0b | NULL  |<br \/>\n&#043;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;&#8212;&#8212;&#8211;&#043;&#8212;&#8212;-&#043;<br \/>\n4 rows in set (0.00 sec)<\/p>\n<h4>2.4 \u63d2\u5165\u5426\u5219\u66f4\u65b0&#xff1a;ON DUPLICATE KEY UPDATE<\/h4>\n<p>\u5f53\u4e3b\u952e\u6216\u552f\u4e00\u952e\u51b2\u7a81\u65f6&#xff0c;\u53ef\u4ee5\u9009\u62e9\u66f4\u65b0\u5df2\u6709\u8bb0\u5f55&#xff1a;<\/p>\n<p><span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> students <span class=\"token punctuation\">(<\/span>id<span class=\"token punctuation\">,<\/span> sn<span class=\"token punctuation\">,<\/span> name<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token keyword\">values<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">10010<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u5510\u5927\u5e08&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token keyword\">on<\/span> <span class=\"token keyword\">duplicate<\/span> <span class=\"token keyword\">key<\/span> <span class=\"token keyword\">update<\/span> sn <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">10010<\/span><span class=\"token punctuation\">,<\/span> name <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;\u5510\u5927\u5e08&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u5f71\u54cd\u884c\u6570\u542b\u4e49&#xff1a;<\/p>\n<ul>\n<li>0 row affected&#xff1a;\u51b2\u7a81\u6570\u636e\u5b58\u5728&#xff0c;\u4f46\u66f4\u65b0\u503c\u4e0e\u539f\u503c\u76f8\u540c&#xff1b;<\/li>\n<li>1 row affected&#xff1a;\u6ca1\u6709\u51b2\u7a81&#xff0c;\u63d2\u5165\u6210\u529f&#xff1b;<\/li>\n<li>2 row affected&#xff1a;\u6709\u51b2\u7a81&#xff0c;\u5e76\u4e14\u6267\u884c\u4e86\u66f4\u65b0\u3002<\/li>\n<\/ul>\n<p>\u53ef\u901a\u8fc7 ROW_COUNT() \u67e5\u770b&#xff1a;<\/p>\n<p><span class=\"token keyword\">select<\/span> row_count<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>2.5 \u66ff\u6362&#xff1a;REPLACE<\/h4>\n<p><span class=\"token keyword\">replace<\/span> <span class=\"token keyword\">into<\/span> students <span class=\"token punctuation\">(<\/span>sn<span class=\"token punctuation\">,<\/span> name<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">values<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">20001<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u66f9\u963f\u7792&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<ul>\n<li>1 row affected&#xff1a;\u65e0\u51b2\u7a81&#xff0c;\u76f4\u63a5\u63d2\u5165&#xff1b;<\/li>\n<li>2 row affected&#xff1a;\u6709\u51b2\u7a81&#xff0c;\u5220\u9664\u65e7\u8bb0\u5f55\u540e\u91cd\u65b0\u63d2\u5165\u3002<\/li>\n<\/ul>\n<hr \/>\n<h3>3. Retrieve&#xff1a;\u67e5\u8be2\u6570\u636e<\/h3>\n<h4>3.1 \u51c6\u5907\u8003\u8bd5\u6210\u7ee9\u8868<\/h4>\n<p><span class=\"token keyword\">create<\/span> <span class=\"token keyword\">table<\/span> exam_result <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">int<\/span> <span class=\"token keyword\">unsigned<\/span> <span class=\"token keyword\">primary<\/span> <span class=\"token keyword\">key<\/span> <span class=\"token keyword\">auto_increment<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    name <span class=\"token keyword\">varchar<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">20<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">not<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">&#039;\u540c\u5b66\u59d3\u540d&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    chinese <span class=\"token keyword\">float<\/span> <span class=\"token keyword\">default<\/span> <span class=\"token number\">0.0<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">&#039;\u8bed\u6587\u6210\u7ee9&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    math <span class=\"token keyword\">float<\/span> <span class=\"token keyword\">default<\/span> <span class=\"token number\">0.0<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">&#039;\u6570\u5b66\u6210\u7ee9&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    english <span class=\"token keyword\">float<\/span> <span class=\"token keyword\">default<\/span> <span class=\"token number\">0.0<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">&#039;\u82f1\u8bed\u6210\u7ee9&#039;<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> exam_result <span class=\"token punctuation\">(<\/span>name<span class=\"token punctuation\">,<\/span> chinese<span class=\"token punctuation\">,<\/span> math<span class=\"token punctuation\">,<\/span> english<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">values<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\u5510\u4e09\u85cf&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">67<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">98<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">56<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\u5b59\u609f\u7a7a&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">87<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">78<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">77<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\u732a\u609f\u80fd&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">88<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">98<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">90<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\u66f9\u5b5f\u5fb7&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">82<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">84<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">67<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\u5218\u7384\u5fb7&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">55<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">85<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">45<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\u5b59\u6743&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">70<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">73<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">78<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\u5b8b\u516c\u660e&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">75<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">65<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">30<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>3.2 SELECT \u5217<\/h4>\n<h5>3.2.1 \u5168\u5217\u67e5\u8be2<\/h5>\n<p><span class=\"token keyword\">select<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">from<\/span> exam_result<span class=\"token punctuation\">;<\/span><\/p>\n<p>\u901a\u5e38\u4e0d\u5efa\u8bae\u4f7f\u7528 select *&#xff0c;\u539f\u56e0\u662f&#xff1a;<\/p>\n<li>\u6570\u636e\u91cf\u5927\u65f6\u4f20\u8f93\u6210\u672c\u9ad8&#xff1b;<\/li>\n<li>\u53ef\u80fd\u5f71\u54cd\u7d22\u5f15\u4f7f\u7528\u3002<\/li>\n<h5>3.2.2 \u6307\u5b9a\u5217\u67e5\u8be2<\/h5>\n<p><span class=\"token keyword\">select<\/span> id<span class=\"token punctuation\">,<\/span> name<span class=\"token punctuation\">,<\/span> english <span class=\"token keyword\">from<\/span> exam_result<span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6307\u5b9a\u5217\u7684\u987a\u5e8f\u4e0d\u9700\u8981\u6309\u5b9a\u4e49\u8868\u7684\u987a\u5e8f\u6765\u3002<\/p>\n<h5>3.2.3 \u67e5\u8be2\u5b57\u6bb5\u4e3a\u8868\u8fbe\u5f0f<\/h5>\n<p><span class=\"token keyword\">select<\/span> id<span class=\"token punctuation\">,<\/span> name<span class=\"token punctuation\">,<\/span> chinese <span class=\"token operator\">&#043;<\/span> math <span class=\"token operator\">&#043;<\/span> english <span class=\"token keyword\">from<\/span> exam_result<span class=\"token punctuation\">;<\/span><\/p>\n<h5>3.2.4 \u4e3a\u67e5\u8be2\u7ed3\u679c\u6307\u5b9a\u522b\u540d<\/h5>\n<p><span class=\"token keyword\">select<\/span> id<span class=\"token punctuation\">,<\/span> name<span class=\"token punctuation\">,<\/span> chinese <span class=\"token operator\">&#043;<\/span> math <span class=\"token operator\">&#043;<\/span> english <span class=\"token keyword\">as<\/span> \u603b\u5206 <span class=\"token keyword\">from<\/span> exam_result<span class=\"token punctuation\">;<\/span><\/p>\n<h5>3.2.5 \u7ed3\u679c\u53bb\u91cd<\/h5>\n<p><span class=\"token keyword\">select<\/span> <span class=\"token keyword\">distinct<\/span> math <span class=\"token keyword\">from<\/span> exam_result<span class=\"token punctuation\">;<\/span><\/p>\n<h4>3.3 WHERE \u6761\u4ef6<\/h4>\n<p>\u5e38\u7528\u6bd4\u8f83\u8fd0\u7b97\u7b26&#xff1a;<\/p>\n<table>\n<tr>\u8fd0\u7b97\u7b26\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>&gt;\u3001&gt;&#061;\u3001&lt;\u3001&lt;&#061;<\/td>\n<td>\u5927\u4e8e\u3001\u5927\u4e8e\u7b49\u4e8e\u3001\u5c0f\u4e8e\u3001\u5c0f\u4e8e\u7b49\u4e8e<\/td>\n<\/tr>\n<tr>\n<td>&#061;<\/td>\n<td>\u7b49\u4e8e&#xff0c;NULL \u4e0d\u5b89\u5168<\/td>\n<\/tr>\n<tr>\n<td>&lt;&#061;&gt;<\/td>\n<td>\u7b49\u4e8e&#xff0c;NULL \u5b89\u5168<\/td>\n<\/tr>\n<tr>\n<td>!&#061;\u3001&lt;&gt;<\/td>\n<td>\u4e0d\u7b49\u4e8e<\/td>\n<\/tr>\n<tr>\n<td>between a0 and a1<\/td>\n<td>\u8303\u56f4\u5339\u914d<\/td>\n<\/tr>\n<tr>\n<td>in (&#8230;)<\/td>\n<td>\u662f\u5426\u5728\u96c6\u5408\u4e2d<\/td>\n<\/tr>\n<tr>\n<td>is null<\/td>\n<td>\u662f\u5426\u4e3a NULL<\/td>\n<\/tr>\n<tr>\n<td>is not null<\/td>\n<td>\u662f\u5426\u4e0d\u4e3a NULL<\/td>\n<\/tr>\n<tr>\n<td>like<\/td>\n<td>\u6a21\u7cca\u5339\u914d&#xff0c;% \u8868\u793a\u4efb\u610f\u591a\u4e2a\u5b57\u7b26&#xff0c;_ \u8868\u793a\u4e00\u4e2a\u5b57\u7b26<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u903b\u8f91\u8fd0\u7b97\u7b26&#xff1a;<\/p>\n<ul>\n<li>and&#xff1a;\u591a\u4e2a\u6761\u4ef6\u90fd\u6210\u7acb&#xff1b;<\/li>\n<li>or&#xff1a;\u4efb\u610f\u4e00\u4e2a\u6761\u4ef6\u6210\u7acb&#xff1b;<\/li>\n<li>not&#xff1a;\u6761\u4ef6\u53d6\u53cd\u3002<\/li>\n<\/ul>\n<p>\u793a\u4f8b&#xff1a;<\/p>\n<p><span class=\"token comment\">&#8212; \u82f1\u8bed\u4e0d\u53ca\u683c<\/span><br \/>\n<span class=\"token keyword\">select<\/span> name<span class=\"token punctuation\">,<\/span> english <span class=\"token keyword\">from<\/span> exam_result <span class=\"token keyword\">where<\/span> english <span class=\"token operator\">&lt;<\/span> <span class=\"token number\">60<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u8bed\u6587\u6210\u7ee9\u5728 [80, 90]<\/span><br \/>\n<span class=\"token keyword\">select<\/span> name<span class=\"token punctuation\">,<\/span> chinese <span class=\"token keyword\">from<\/span> exam_result<br \/>\n<span class=\"token keyword\">where<\/span> chinese <span class=\"token operator\">between<\/span> <span class=\"token number\">80<\/span> <span class=\"token operator\">and<\/span> <span class=\"token number\">90<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u6570\u5b66\u6210\u7ee9\u662f 58\u300159\u300198\u300199<\/span><br \/>\n<span class=\"token keyword\">select<\/span> name<span class=\"token punctuation\">,<\/span> math <span class=\"token keyword\">from<\/span> exam_result<br \/>\n<span class=\"token keyword\">where<\/span> math <span class=\"token operator\">in<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">58<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">59<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">98<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">99<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u59d3\u5b59\u7684\u540c\u5b66<\/span><br \/>\n<span class=\"token keyword\">select<\/span> name <span class=\"token keyword\">from<\/span> exam_result <span class=\"token keyword\">where<\/span> name <span class=\"token operator\">like<\/span> <span class=\"token string\">&#039;\u5b59%&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u5b59\u67d0\u540c\u5b66&#xff0c;\u4e25\u683c\u4e24\u4e2a\u5b57\u7b26<\/span><br \/>\n<span class=\"token keyword\">select<\/span> name <span class=\"token keyword\">from<\/span> exam_result <span class=\"token keyword\">where<\/span> name <span class=\"token operator\">like<\/span> <span class=\"token string\">&#039;\u5b59_&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u8bed\u6587\u9ad8\u4e8e\u82f1\u8bed<\/span><br \/>\n<span class=\"token keyword\">select<\/span> name<span class=\"token punctuation\">,<\/span> chinese<span class=\"token punctuation\">,<\/span> english <span class=\"token keyword\">from<\/span> exam_result<br \/>\n<span class=\"token keyword\">where<\/span> chinese <span class=\"token operator\">&gt;<\/span> english<span class=\"token punctuation\">;<\/span><\/p>\n<p>NULL \u6bd4\u8f83&#xff1a;&#061; \u4e0e &lt;&#061;&gt;<\/p>\n<p><span class=\"token keyword\">select<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token boolean\">null<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token comment\">&#8212; \u7ed3\u679c\u90fd\u662f NULL<\/span><\/p>\n<p><span class=\"token keyword\">select<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token operator\">&lt;&#061;&gt;<\/span> <span class=\"token boolean\">null<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token operator\">&lt;&#061;&gt;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token operator\">&lt;&#061;&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token comment\">&#8212; \u7ed3\u679c&#xff1a;1, 0, 0<\/span><\/p>\n<p>\u56e0\u6b64\u5224\u65ad NULL \u5e94\u4f7f\u7528&#xff1a;<\/p>\n<p><span class=\"token keyword\">select<\/span> name<span class=\"token punctuation\">,<\/span> qq <span class=\"token keyword\">from<\/span> students <span class=\"token keyword\">where<\/span> qq <span class=\"token operator\">is<\/span> <span class=\"token operator\">not<\/span> <span class=\"token boolean\">null<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>3.4 ORDER BY \u6392\u5e8f<\/h4>\n<p><span class=\"token keyword\">select<\/span> name<span class=\"token punctuation\">,<\/span> math <span class=\"token keyword\">from<\/span> exam_result <span class=\"token keyword\">order<\/span> <span class=\"token keyword\">by<\/span> math<span class=\"token punctuation\">;<\/span><\/p>\n<ul>\n<li>\u9ed8\u8ba4 asc \u5347\u5e8f&#xff1b;<\/li>\n<li>desc \u4e3a\u964d\u5e8f&#xff1b;<\/li>\n<li>NULL \u89c6\u4e3a\u6bd4\u4efb\u4f55\u503c\u90fd\u5c0f&#xff1b;<\/li>\n<li>\u6ca1\u6709 order by \u65f6&#xff0c;\u8fd4\u56de\u987a\u5e8f\u672a\u5b9a\u4e49\u3002<\/li>\n<\/ul>\n<p>\u591a\u5b57\u6bb5\u6392\u5e8f&#xff1a;<\/p>\n<p><span class=\"token keyword\">select<\/span> name<span class=\"token punctuation\">,<\/span> math<span class=\"token punctuation\">,<\/span> english<span class=\"token punctuation\">,<\/span> chinese<br \/>\n<span class=\"token keyword\">from<\/span> exam_result<br \/>\n<span class=\"token keyword\">order<\/span> <span class=\"token keyword\">by<\/span> math <span class=\"token keyword\">desc<\/span><span class=\"token punctuation\">,<\/span> english<span class=\"token punctuation\">,<\/span> chinese<span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4f7f\u7528\u522b\u540d\u6392\u5e8f&#xff1a;<\/p>\n<p><span class=\"token keyword\">select<\/span> name<span class=\"token punctuation\">,<\/span> chinese <span class=\"token operator\">&#043;<\/span> english <span class=\"token operator\">&#043;<\/span> math <span class=\"token keyword\">as<\/span> \u603b\u5206<br \/>\n<span class=\"token keyword\">from<\/span> exam_result<br \/>\n<span class=\"token keyword\">order<\/span> <span class=\"token keyword\">by<\/span> \u603b\u5206 <span class=\"token keyword\">desc<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>3.5 LIMIT \u5206\u9875<\/h4>\n<p><span class=\"token comment\">&#8212; \u4ece\u7b2c 0 \u6761\u5f00\u59cb&#xff0c;\u53d6 3 \u6761<\/span><br \/>\n<span class=\"token keyword\">select<\/span> id<span class=\"token punctuation\">,<\/span> name<span class=\"token punctuation\">,<\/span> math<span class=\"token punctuation\">,<\/span> english<span class=\"token punctuation\">,<\/span> chinese<br \/>\n<span class=\"token keyword\">from<\/span> exam_result<br \/>\n<span class=\"token keyword\">order<\/span> <span class=\"token keyword\">by<\/span> id<br \/>\n<span class=\"token keyword\">limit<\/span> <span class=\"token number\">3<\/span> <span class=\"token keyword\">offset<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u4ece\u7b2c 3 \u6761\u5f00\u59cb&#xff0c;\u53d6 3 \u6761<\/span><br \/>\n<span class=\"token keyword\">select<\/span> id<span class=\"token punctuation\">,<\/span> name<span class=\"token punctuation\">,<\/span> math<span class=\"token punctuation\">,<\/span> english<span class=\"token punctuation\">,<\/span> chinese<br \/>\n<span class=\"token keyword\">from<\/span> exam_result<br \/>\n<span class=\"token keyword\">order<\/span> <span class=\"token keyword\">by<\/span> id<br \/>\n<span class=\"token keyword\">limit<\/span> <span class=\"token number\">3<\/span> <span class=\"token keyword\">offset<\/span> <span class=\"token number\">3<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u5efa\u8bae\u67e5\u8be2\u672a\u77e5\u5927\u8868\u65f6\u52a0 limit 1&#xff0c;\u907f\u514d\u5168\u8868\u626b\u63cf\u5bfc\u81f4\u6570\u636e\u5e93\u538b\u529b\u8fc7\u5927\u3002<\/p>\n<hr \/>\n<h3>4. Update&#xff1a;\u66f4\u65b0\u6570\u636e<\/h3>\n<p>\u8bed\u6cd5&#xff1a;<\/p>\n<p><span class=\"token keyword\">update<\/span> table_name<br \/>\n<span class=\"token keyword\">set<\/span> <span class=\"token keyword\">column<\/span> <span class=\"token operator\">&#061;<\/span> expr <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">column<\/span> <span class=\"token operator\">&#061;<\/span> expr <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token punctuation\">[<\/span><span class=\"token keyword\">where<\/span> <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token punctuation\">[<\/span><span class=\"token keyword\">order<\/span> <span class=\"token keyword\">by<\/span> <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token punctuation\">[<\/span><span class=\"token keyword\">limit<\/span> <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u793a\u4f8b&#xff1a;<\/p>\n<p><span class=\"token keyword\">update<\/span> exam_result <span class=\"token keyword\">set<\/span> math <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">80<\/span> <span class=\"token keyword\">where<\/span> name <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;\u5b59\u609f\u7a7a&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">update<\/span> exam_result<br \/>\n<span class=\"token keyword\">set<\/span> math <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">60<\/span><span class=\"token punctuation\">,<\/span> chinese <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">70<\/span><br \/>\n<span class=\"token keyword\">where<\/span> name <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;\u66f9\u5b5f\u5fb7&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u66f4\u65b0\u65f6\u57fa\u4e8e\u539f\u503c\u8ba1\u7b97&#xff1a;<\/p>\n<p><span class=\"token keyword\">update<\/span> exam_result<br \/>\n<span class=\"token keyword\">set<\/span> math <span class=\"token operator\">&#061;<\/span> math <span class=\"token operator\">&#043;<\/span> <span class=\"token number\">30<\/span><br \/>\n<span class=\"token keyword\">order<\/span> <span class=\"token keyword\">by<\/span> chinese <span class=\"token operator\">&#043;<\/span> math <span class=\"token operator\">&#043;<\/span> english<br \/>\n<span class=\"token keyword\">limit<\/span> <span class=\"token number\">3<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6ce8\u610f&#xff1a;MySQL \u4e0d\u652f\u6301 math &#043;&#061; 30 \u8fd9\u79cd\u5199\u6cd5\u3002<\/p>\n<p>\u6ca1\u6709 where \u65f6\u4f1a\u66f4\u65b0\u5168\u8868&#xff0c;\u52a1\u5fc5\u8c28\u614e&#xff1a;<\/p>\n<p><span class=\"token keyword\">update<\/span> exam_result <span class=\"token keyword\">set<\/span> chinese <span class=\"token operator\">&#061;<\/span> chinese <span class=\"token operator\">*<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<hr \/>\n<h3>5. Delete&#xff1a;\u5220\u9664\u6570\u636e<\/h3>\n<p>\u8bed\u6cd5&#xff1a;<\/p>\n<p><span class=\"token keyword\">delete<\/span> <span class=\"token keyword\">from<\/span> table_name<br \/>\n<span class=\"token punctuation\">[<\/span><span class=\"token keyword\">where<\/span> <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token punctuation\">[<\/span><span class=\"token keyword\">order<\/span> <span class=\"token keyword\">by<\/span> <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token punctuation\">[<\/span><span class=\"token keyword\">limit<\/span> <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u5220\u9664\u6307\u5b9a\u8bb0\u5f55&#xff1a;<\/p>\n<p><span class=\"token keyword\">delete<\/span> <span class=\"token keyword\">from<\/span> exam_result <span class=\"token keyword\">where<\/span> name <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;\u5b59\u609f\u7a7a&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u5220\u9664\u6574\u8868&#xff1a;<\/p>\n<p><span class=\"token keyword\">delete<\/span> <span class=\"token keyword\">from<\/span> for_delete<span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6ce8\u610f&#xff1a;delete \u5220\u9664\u5168\u8868\u540e&#xff0c;\u81ea\u589e\u4e3b\u952e\u4e0d\u4f1a\u91cd\u7f6e\u3002\u518d\u6b21\u63d2\u5165\u65f6&#xff0c;auto_increment \u4f1a\u7ee7\u7eed\u589e\u957f\u3002<\/p>\n<p>\u5982\u679c\u9700\u8981\u91cd\u7f6e\u81ea\u589e&#xff0c;\u53ef\u4f7f\u7528&#xff1a;<\/p>\n<p><span class=\"token keyword\">truncate<\/span> <span class=\"token keyword\">table<\/span> for_truncate<span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4f46 truncate \u5c5e\u4e8e\u66f4\u5371\u9669\u7684\u64cd\u4f5c&#xff0c;\u4f1a\u6e05\u7a7a\u6574\u8868\u5e76\u91cd\u7f6e\u81ea\u589e&#xff0c;\u4f7f\u7528\u524d\u9700\u786e\u8ba4\u3002<\/p>\n<hr \/>\n<h3>6. \u63d2\u5165\u67e5\u8be2\u7ed3\u679c\u4e0e\u53bb\u91cd<\/h3>\n<p>\u8bed\u6cd5&#xff1a;<\/p>\n<p><span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> table_name <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">column<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">column<\/span> <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token keyword\">select<\/span> <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6848\u4f8b&#xff1a;\u5220\u9664\u91cd\u590d\u8bb0\u5f55&#xff0c;\u53ea\u4fdd\u7559\u4e00\u4efd\u3002<\/p>\n<p><span class=\"token keyword\">create<\/span> <span class=\"token keyword\">table<\/span> duplicate_table <span class=\"token punctuation\">(<\/span>id <span class=\"token keyword\">int<\/span><span class=\"token punctuation\">,<\/span> name <span class=\"token keyword\">varchar<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">20<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> duplicate_table <span class=\"token keyword\">values<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;aaa&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;aaa&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token number\">200<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;bbb&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">200<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;bbb&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">200<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;bbb&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">(<\/span><span class=\"token number\">300<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;ccc&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u521b\u5efa\u7ed3\u6784\u76f8\u540c\u7684\u7a7a\u8868<\/span><br \/>\n<span class=\"token keyword\">create<\/span> <span class=\"token keyword\">table<\/span> no_duplicate_table <span class=\"token operator\">like<\/span> duplicate_table<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u63d2\u5165\u53bb\u91cd\u540e\u7684\u6570\u636e<\/span><br \/>\n<span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> no_duplicate_table<br \/>\n<span class=\"token keyword\">select<\/span> <span class=\"token keyword\">distinct<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">from<\/span> duplicate_table<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u91cd\u547d\u540d\u8868&#xff0c;\u5b9e\u73b0\u539f\u5b50\u66ff\u6362<\/span><br \/>\n<span class=\"token keyword\">rename<\/span> <span class=\"token keyword\">table<\/span> duplicate_table <span class=\"token keyword\">to<\/span> old_duplicate_table<span class=\"token punctuation\">,<\/span><br \/>\n             no_duplicate_table <span class=\"token keyword\">to<\/span> duplicate_table<span class=\"token punctuation\">;<\/span><\/p>\n<hr \/>\n<h3>7. \u805a\u5408\u51fd\u6570<\/h3>\n<table>\n<tr>\u51fd\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>count([distinct] expr)<\/td>\n<td>\u8fd4\u56de\u6570\u636e\u6570\u91cf<\/td>\n<\/tr>\n<tr>\n<td>sum([distinct] expr)<\/td>\n<td>\u6c42\u548c&#xff0c;\u975e\u6570\u5b57\u65e0\u610f\u4e49<\/td>\n<\/tr>\n<tr>\n<td>avg([distinct] expr)<\/td>\n<td>\u5e73\u5747\u503c<\/td>\n<\/tr>\n<tr>\n<td>max([distinct] expr)<\/td>\n<td>\u6700\u5927\u503c<\/td>\n<\/tr>\n<tr>\n<td>min([distinct] expr)<\/td>\n<td>\u6700\u5c0f\u503c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u793a\u4f8b&#xff1a;<\/p>\n<p><span class=\"token keyword\">select<\/span> <span class=\"token function\">count<\/span><span class=\"token punctuation\">(<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">from<\/span> students<span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">select<\/span> <span class=\"token function\">count<\/span><span class=\"token punctuation\">(<\/span>qq<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">from<\/span> students<span class=\"token punctuation\">;<\/span> <span class=\"token comment\">&#8212; NULL \u4e0d\u8ba1\u5165<\/span><br \/>\n<span class=\"token keyword\">select<\/span> <span class=\"token function\">count<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">distinct<\/span> math<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">from<\/span> exam_result<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">select<\/span> <span class=\"token function\">sum<\/span><span class=\"token punctuation\">(<\/span>math<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">from<\/span> exam_result<span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">select<\/span> <span class=\"token function\">avg<\/span><span class=\"token punctuation\">(<\/span>chinese <span class=\"token operator\">&#043;<\/span> math <span class=\"token operator\">&#043;<\/span> english<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> \u5e73\u5747\u603b\u5206 <span class=\"token keyword\">from<\/span> exam_result<span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">select<\/span> <span class=\"token function\">max<\/span><span class=\"token punctuation\">(<\/span>english<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">from<\/span> exam_result<span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">select<\/span> <span class=\"token function\">min<\/span><span class=\"token punctuation\">(<\/span>math<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">from<\/span> exam_result <span class=\"token keyword\">where<\/span> math <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">70<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<hr \/>\n<h3>8. GROUP BY \u4e0e HAVING<\/h3>\n<p>group by \u7528\u4e8e\u5206\u7ec4\u67e5\u8be2\u3002<\/p>\n<p><span class=\"token keyword\">select<\/span> deptno<span class=\"token punctuation\">,<\/span> <span class=\"token function\">avg<\/span><span class=\"token punctuation\">(<\/span>sal<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">max<\/span><span class=\"token punctuation\">(<\/span>sal<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token keyword\">from<\/span> emp<br \/>\n<span class=\"token keyword\">group<\/span> <span class=\"token keyword\">by<\/span> deptno<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">select<\/span> deptno<span class=\"token punctuation\">,<\/span> job<span class=\"token punctuation\">,<\/span> <span class=\"token function\">avg<\/span><span class=\"token punctuation\">(<\/span>sal<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">min<\/span><span class=\"token punctuation\">(<\/span>sal<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token keyword\">from<\/span> emp<br \/>\n<span class=\"token keyword\">group<\/span> <span class=\"token keyword\">by<\/span> deptno<span class=\"token punctuation\">,<\/span> job<span class=\"token punctuation\">;<\/span><\/p>\n<p>having \u7528\u4e8e\u5bf9\u5206\u7ec4\u7ed3\u679c\u8fc7\u6ee4&#xff1a;<\/p>\n<p><span class=\"token keyword\">select<\/span> <span class=\"token function\">avg<\/span><span class=\"token punctuation\">(<\/span>sal<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> myavg<br \/>\n<span class=\"token keyword\">from<\/span> emp<br \/>\n<span class=\"token keyword\">group<\/span> <span class=\"token keyword\">by<\/span> deptno<br \/>\n<span class=\"token keyword\">having<\/span> myavg <span class=\"token operator\">&lt;<\/span> <span class=\"token number\">2000<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>where \u8fc7\u6ee4\u884c&#xff0c;having \u8fc7\u6ee4\u5206\u7ec4&#xff0c;\u4e8c\u8005\u5e38\u914d\u5408 group by \u4f7f\u7528\u3002<\/p>\n<hr \/>\n<h3>9. \u5b9e\u6218 OJ \u4e0e\u6267\u884c\u987a\u5e8f<\/h3>\n<p>\u5e38\u89c1 OJ \u9898\u76ee&#xff1a;<\/p>\n<ul>\n<li>\u725b\u5ba2&#xff1a;\u6279\u91cf\u63d2\u5165\u6570\u636e<\/li>\n<li>\u725b\u5ba2&#xff1a;\u627e\u51fa\u6240\u6709\u5458\u5de5\u5f53\u524d\u85aa\u6c34&#xff0c;\u76f8\u540c\u85aa\u6c34\u53ea\u663e\u793a\u4e00\u6b21&#xff0c;\u9006\u5e8f\u663e\u793a<\/li>\n<li>\u725b\u5ba2&#xff1a;\u67e5\u627e\u6700\u665a\u5165\u804c\u5458\u5de5\u7684\u6240\u6709\u4fe1\u606f<\/li>\n<li>\u725b\u5ba2&#xff1a;\u67e5\u627e\u5165\u804c\u65f6\u95f4\u6392\u540d\u5012\u6570\u7b2c\u4e09\u7684\u5458\u5de5\u4fe1\u606f<\/li>\n<li>\u725b\u5ba2&#xff1a;\u67e5\u627e\u85aa\u6c34\u6da8\u5e45\u8d85\u8fc7 15 \u6b21\u7684\u5458\u5de5\u53f7\u53ca\u6da8\u5e45\u6b21\u6570<\/li>\n<li>LeetCode&#xff1a;duplicate-emails\u3001big-countries\u3001nth-highest-salary<\/li>\n<\/ul>\n<p>\u9762\u8bd5\u5e38\u89c1\u95ee\u9898&#xff1a;SQL \u67e5\u8be2\u4e2d\u5173\u952e\u5b57\u7684\u6267\u884c\u5148\u540e\u987a\u5e8f\u5927\u81f4\u4e3a&#xff1a;<\/p>\n<p>from &gt; on &gt; join &gt; where &gt; group by &gt; with &gt; having &gt; select &gt; distinct &gt; order by &gt; limit<\/p>\n<p>\u7406\u89e3\u6267\u884c\u987a\u5e8f\u6709\u52a9\u4e8e\u5206\u6790\u522b\u540d\u3001\u805a\u5408\u3001\u6392\u5e8f\u548c\u8fc7\u6ee4\u6761\u4ef6\u4e3a\u4ec0\u4e48\u80fd\u6216\u4e0d\u80fd\u5728\u67d0\u4e9b\u4f4d\u7f6e\u4f7f\u7528\u3002<\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>\u76ee\u5f551. CRUD \u6982\u8ff02. Create&#xff1a;\u63d2\u5165\u6570\u636e2.1 \u521b\u5efa\u5b66\u751f\u88682.2 \u5355\u884c  \u5168\u5217\u63d2\u51652.3 \u591a\u884c  \u6307\u5b9a\u5217\u63d2\u51652.4 \u63d2\u5165\u5426\u5219\u66f4\u65b0&#xff1a;ON DUPLICATE KEY UPDATE2.5 \u66ff\u6362&#xff1a;REPLACE3. Retrieve&#xff1a;\u67e5\u8be2\u6570\u636e3.1 \u51c6\u5907\u8003\u8bd5\u6210\u7ee9\u88683.2 SELECT \u52173.2.1 \u5168\u5217\u67e5\u8be23.2.2 \u6307\u5b9a\u5217\u67e5\u8be23.2.3 \u67e5\u8be2\u5b57\u6bb5\u4e3a\u8868\u8fbe\u5f0f3.2.4 \u4e3a\u67e5\u8be2\u7ed3\u679c\u6307\u5b9a\u522b\u540d3.2.5 \u7ed3\u679c\u53bb\u91cd3.3 W<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[993,292,190,305],"topic":[],"class_list":["post-106819","post","type-post","status-publish","format-standard","hentry","category-server","tag-993","tag-292","tag-190","tag-305"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL \u57fa\u672c\u67e5\u8be2\uff086\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/106819.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL \u57fa\u672c\u67e5\u8be2\uff086\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u76ee\u5f551. CRUD \u6982\u8ff02. Create&#xff1a;\u63d2\u5165\u6570\u636e2.1 \u521b\u5efa\u5b66\u751f\u88682.2 \u5355\u884c \u5168\u5217\u63d2\u51652.3 \u591a\u884c \u6307\u5b9a\u5217\u63d2\u51652.4 \u63d2\u5165\u5426\u5219\u66f4\u65b0&#xff1a;ON DUPLICATE KEY UPDATE2.5 \u66ff\u6362&#xff1a;REPLACE3. Retrieve&#xff1a;\u67e5\u8be2\u6570\u636e3.1 \u51c6\u5907\u8003\u8bd5\u6210\u7ee9\u88683.2 SELECT \u52173.2.1 \u5168\u5217\u67e5\u8be23.2.2 \u6307\u5b9a\u5217\u67e5\u8be23.2.3 \u67e5\u8be2\u5b57\u6bb5\u4e3a\u8868\u8fbe\u5f0f3.2.4 \u4e3a\u67e5\u8be2\u7ed3\u679c\u6307\u5b9a\u522b\u540d3.2.5 \u7ed3\u679c\u53bb\u91cd3.3 W\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/106819.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-18T03:32:39+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/106819.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/106819.html\",\"name\":\"MySQL \u57fa\u672c\u67e5\u8be2\uff086\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-09-18T03:32:39+00:00\",\"dateModified\":\"2026-09-18T03:32:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/106819.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/106819.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/106819.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL \u57fa\u672c\u67e5\u8be2\uff086\uff09\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL \u57fa\u672c\u67e5\u8be2\uff086\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","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:\/\/www.wsisp.com\/helps\/106819.html","og_locale":"zh_CN","og_type":"article","og_title":"MySQL \u57fa\u672c\u67e5\u8be2\uff086\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u76ee\u5f551. CRUD \u6982\u8ff02. Create&#xff1a;\u63d2\u5165\u6570\u636e2.1 \u521b\u5efa\u5b66\u751f\u88682.2 \u5355\u884c \u5168\u5217\u63d2\u51652.3 \u591a\u884c \u6307\u5b9a\u5217\u63d2\u51652.4 \u63d2\u5165\u5426\u5219\u66f4\u65b0&#xff1a;ON DUPLICATE KEY UPDATE2.5 \u66ff\u6362&#xff1a;REPLACE3. Retrieve&#xff1a;\u67e5\u8be2\u6570\u636e3.1 \u51c6\u5907\u8003\u8bd5\u6210\u7ee9\u88683.2 SELECT \u52173.2.1 \u5168\u5217\u67e5\u8be23.2.2 \u6307\u5b9a\u5217\u67e5\u8be23.2.3 \u67e5\u8be2\u5b57\u6bb5\u4e3a\u8868\u8fbe\u5f0f3.2.4 \u4e3a\u67e5\u8be2\u7ed3\u679c\u6307\u5b9a\u522b\u540d3.2.5 \u7ed3\u679c\u53bb\u91cd3.3 W","og_url":"https:\/\/www.wsisp.com\/helps\/106819.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-09-18T03:32:39+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/106819.html","url":"https:\/\/www.wsisp.com\/helps\/106819.html","name":"MySQL \u57fa\u672c\u67e5\u8be2\uff086\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-09-18T03:32:39+00:00","dateModified":"2026-09-18T03:32:39+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/106819.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/106819.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/106819.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"MySQL \u57fa\u672c\u67e5\u8be2\uff086\uff09"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/106819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=106819"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/106819\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=106819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=106819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=106819"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=106819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}