{"id":106697,"date":"2019-11-17T18:10:23","date_gmt":"2019-11-17T10:10:23","guid":{"rendered":"https:\/\/www.lixiangluntan.com\/106697.html"},"modified":"2019-11-17T18:10:23","modified_gmt":"2019-11-17T10:10:23","slug":"%e8%82%a1%e7%a5%a8%e6%8c%87%e6%a0%87%e5%85%ac%e5%bc%8f%e8%a7%a3%e7%9b%98%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.lixiangluntan.com\/?p=106697","title":{"rendered":"\u80a1\u7968\u6307\u6807\u516c\u5f0f\u89e3\u76d8\u51fd\u6570"},"content":{"rendered":"<blockquote style=\"font-size:15px;background-color: #F5F5F5;border:none;padding: 5px;margin:15px;line-height: 1.6;text-indent: 2em;\">\n<p style=\"margin-bottom:5px;\">\u901a\u8fbe\u4fe1\u4e0e\u98de\u72d0\u53ef\u76f8\u4e92\u66ff\u6362\u7684\u51fd\u6570<\/p>\n<\/p>\n<\/blockquote>\n<p><a href=\"http:\/\/www.lixiangluntan.com\" target=\"_blank\" rel=\"noopener noreferrer\">\u80a1\u7968\u516c\u5f0f\u7f51<\/a><\/p>\n<p class=\"description\">\n<div class=\"gsdxg\">\n<\/div>\n<p>\u51fd\u6570\uff1a EXPLAIN(COND,TEXT)<br \/> \u522b\u540d\uff1a \u663e\u793a\u89e3\u76d8\u6587\u5b57<\/p>\n<p>\u53c2\u6570\uff1a \u65e0<\/p>\n<p>\u8fd4\u56de\uff1a \u65e0<br \/> \u8bf4\u660e\uff1a EXPLAIN(COND,TEXT),\u5728COND\u6761\u4ef6\u6ee1\u8db3\u65f6\u5728[\u89e3]\u4e2d\u8f93\u51fa\u89e3\u76d8\u6587\u5b57,\u53ef\u7528'\\n'\u7a7a\u4e00\u884c\u3002<br \/> \u793a\u4f8b\uff1a EXPLAIN(HIGH&gt;=HHV(HIGH,20), '\u521b20\u5929\u65b0\u9ad8\\n')\u8868\u793a\u5728\u521b20\u5929\u65b0\u9ad8\u65f6\u5728[\u89e3]\u4e2d\u8f93\u51fa\u89e3\u8bf4\u5e76\u7a7a1\u884c\u663e\u793a\u4e0b\u6761\u89e3\u76d8\u6587\u5b57\u3002<\/p>\n<p>--------------------------------------------------------------------------------<br \/> \u51fd\u6570\uff1a EXPLAINEX(COND,TEXT,NUMBER,PRECISION,SKIPLINES)<br \/> \u522b\u540d\uff1a \u663e\u793a\u89e3\u76d8\u6570\u503c<\/p>\n<p>\u53c2\u6570\uff1a \u65e0<\/p>\n<p>\u8fd4\u56de\uff1a \u65e0<br \/> \u8bf4\u660e\uff1a \u5728COND\u6761\u4ef6\u6ee1\u8db3\u65f6\u5728[\u89e3]\u4e2d\u8f93\u51fa\u6570\u503c\u89e3\u8bf4\u3002<\/p>\n<p>PRECISION\u4e3a\u5c0f\u6570\u663e\u793a\u4f4d\u6570,SKIPLINES\u4e3a\u7a7a\u51fa\u51e0\u884c\u663e\u793a\u4e0b\u4e00\u4e2a\u89e3\u76d8<\/p>\n<p>\u793a\u4f8b\uff1a EXPLAINEX(HIGH&gt;=HHV(HIGH,20), '20\u5929\u65b0\u9ad8\u4ef7:',HIGH,2,1)\u8868\u793a\u5728\u521b20\u5929\u65b0\u9ad8\u65f6\u5728[\u89e3]\u4e2d\u8f93\u51fa\u6570\u503c\u89e3\u8bf4\u3002<\/p>\n<p>--------------------------------------------------------------------------------<br \/> \u51fd\u6570\uff1a EXPLAINICON(COND,ICON)<br \/> \u522b\u540d\uff1a \u753b\u89e3\u76d8\u56fe\u6807<\/p>\n<p>\u53c2\u6570\uff1a \u65e0<\/p>\n<p>\u8fd4\u56de\uff1a \u65e0<br \/> \u8bf4\u660e\uff1a \u5728COND\u6761\u4ef6\u6ee1\u8db3\u65f6\u5728[\u89e3]\u4e2d\u7ed8\u5236\u89e3\u76d8\u56fe\u6807,ICON\u4e3a\u6570\u5b57\u65f64\u79cd\u56fe\u6807\u7f16\u7801\u4e3a1-4(\u9634\u96e8\u3001\u521d\u5f69\u3001\u4e2d\u5f69\u3001\u5f69\u8679)\u3002\u4e3a\u5b57\u7b26\u4e32\u8868\u793a\u81ea\u5236\u56fe\u6807<\/p>\n<p>\u793a\u4f8b\uff1a EXPLAINICON(HIGH&gt;=HHV(HIGH,20), 2)\u8868\u793a\u5728\u521b20\u5929\u65b0\u9ad8\u65f6\u5728[\u89e3]\u4e2d\u753b2\u53f7\u56fe\u6807\uff08\u96e8\u540e\u521d\u5f69\u8679\uff09\u3002<br \/> EXPLAINICON(HIGH&gt;=HHV(HIGH,20), 'MyBMP')\u8868\u793a\u5728\u521b20\u5929\u65b0\u9ad8\u65f6\u5728[\u89e3]\u4e2d\u753bFmlDLL\u5b50\u76ee\u5f55\u4e0b\u7684\u81ea\u5236\u56fe\u6807MyBMP.BMP\u3002<br \/> \u53ef\u7528ALIGN0\u4e2d\u5bf9\u9f50,ALIGN1\u5de6\u5bf9\u9f50,ALIGN2\u53f3\u5bf9\u9f50<\/p>\n<div class=\"yuansheng1\">\n<div class=\"_1a77a5b7w7ei\"><\/div>\n<p> <script type=\"text\/javascript\">\n    (window.slotbydup = window.slotbydup || []).push({\n        id: \"u6133514\",\n        container: \"_1a77a5b7w7ei\",\n        async: true\n    });\n<\/script>\n<\/div>\n<p>{\u80a1\u7968\u8d44\u6e90\u9986:www.lixiangluntan.com\u4e13\u4e1a\u548c\u8c10\u9ad8\u7aef\u7092\u80a1\u8f6f\u4ef6--\u516c\u5f0f\u7f16\u5199\u4ea4\u6d41--\u52a0QQ751161480--}<\/p>\n<blockquote style=\"font-size:15px;background-color: #F5F5F5;border:none;padding: 5px;margin:15px;line-height: 1.6;text-indent: 2em;\">\n<p style=\"margin-bottom:5px;\">\u3010\u80a1\u7968\u8d44\u6e90\u9986\u3011\u80a1\u7968\u8f6f\u4ef6\u7834\u89e3,\u5927\u667a\u6167\u8f6f\u4ef6\u7834\u89e3,\u901a\u8fbe\u4fe1\u8f6f\u4ef6\u7834\u89e3,\u6307\u5357\u9488\u8f6f\u4ef6\u7834\u89e3,\u5927\u667a\u6167\u7b56\u7565\u6295\u8d44\u7ec8\u7aef\u7834\u89e3\u7248,\u5927\u667a\u6167\u6caa\u6df110\u6863L2\u6570\u636e,\u7406\u60f3\u8bba\u575b,\u516c\u5f0f\u6307\u6807\u7f16\u5199\u3002<\/p>\n<\/blockquote>\n<blockquote style=\"font-size:15px;background-color: #F5F5F5;border:none;padding: 5px;margin:15px;line-height: 1.6;text-indent: 2em;\">\n<p style=\"margin-bottom:5px;\">\u80a1\u7968\u6307\u6807\u516c\u5f0f\u63a7\u5236\u8bed\u53e5<\/p>\n<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>\u901a\u8fbe\u4fe1\u4e0e\u98de\u72d0\u53ef\u76f8\u4e92\u66ff\u6362\u7684\u51fd\u6570 \u80a1\u7968\u516c\u5f0f\u7f51 \u51fd\u6570\uff1a EXPLAIN(COND,TEXT) \u522b\u540d\uff1a \u663e\u793a\u89e3\u76d8\u6587\u5b57  ...<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[181],"tags":[182],"class_list":["post-106697","post","type-post","status-publish","format-standard","hentry","category-gsjc","tag-182"],"_links":{"self":[{"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/posts\/106697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=106697"}],"version-history":[{"count":0,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/posts\/106697\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=106697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=106697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=106697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}