{"id":13115,"date":"2024-05-27T17:26:02","date_gmt":"2024-05-27T09:26:02","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=13115"},"modified":"2024-05-28T13:47:31","modified_gmt":"2024-05-28T05:47:31","slug":"sqlbook%e5%a6%82%e4%bd%95%e6%a0%b9%e6%8d%aesql%e5%86%85%e5%ae%b9%e6%89%be%e5%88%b0%e7%9b%ae%e5%bd%95%e6%a0%91","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=13115","title":{"rendered":"sqlbook\u5982\u4f55\u6839\u636esql\u5185\u5bb9\u627e\u5230\u76ee\u5f55\u6811"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<hr \/>\n<p>\u672c\u6587\u4e3b\u8981\u4ecb\u7ecd\uff0c\u5982\u4f55\u6839\u636esql\u4e2d\u7684\u5173\u952e\u5b57\uff0c\u6392\u67e5\u51fa\u54ea\u4e9b\u76ee\u5f55\u6811\u4e0b\u7684sql\u6587\u4ef6\u5728\u4f7f\u7528\u3002<\/p>\n<p><strong>\u6d4b\u8bd5\u7248\u672c\uff1astudio3.3.0-final<\/strong><\/p>\n<h3>\u8be6\u7ec6\u8bf4\u660e<\/h3>\n<hr \/>\n<h4>\u6784\u90202\u4e2asqlbook\u6587\u4ef6\uff0c\u5206\u522b\u5728\u4e0d\u540c\u7684\u76ee\u5f55\u6811\u4e0b<\/h4>\n<p><strong>\u7b2c\u4e00\u4e2asql\u6587\u4ef6\uff0c<\/strong><\/p>\n<ul>\n<li>\u76ee\u5f55\u6811\u5c42\u7ea7\u4e3a\uff1asql\u6587\u4ef6\u593901\/sql\u6587\u4ef6\u593902\u5c42\/sql\u6587\u4ef6\u593903\u5c42\/\u5e95\u5c42sql\u6587\u4ef6<\/li>\n<li>sql\u5185\u5bb9\u4e3a\uff1aselect * from emp_holo;<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/05\/image-1716801674702.png\" alt=\"file\" \/><\/p>\n<p><strong>\u7b2c\u4e8c\u4e2asql\u6587\u4ef6\uff0c<\/strong><\/p>\n<ul>\n<li>\u76ee\u5f55\u6811\u5c42\u7ea7\u4e3a\uff1alkw\/\u5e95\u5c42sql\u6587\u4ef602<\/li>\n<li>sql\u5185\u5bb9\u4e3a\uff1aSELECT * FROM EMP_HOLO LIMIT 100;<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/05\/image-1716801743315.png\" alt=\"file\" \/><\/p>\n<h4>\u67e5\u627e\u76ee\u5f55\u6811\u7ed3\u6784<\/h4>\n<p>\u8fd9\u91cc\uff0c\u6b63\u6587\u5f00\u59cb\uff0c\u5ba2\u6237\u6709\u8fd9\u6837\u4e00\u4e2a\u8bc9\u6c42\uff0c\u201c\u9700\u8981\u67e5\u627e\u51fa\uff0c\u6240\u6709\u5305\u542bemp_holo\u8868\u540d\u7684sqlbook\u6587\u4ef6\u7684\u76ee\u5f55\u6811\u201d\u3002<\/p>\n<p>\u6211\u4eec\u767b\u5f55tds\u5e95\u5c42\u7684\u5143\u6570\u636e\u5e93\uff0c\u4e00\u822c\u4e3akundb\uff0c\u6267\u884c\u5982\u4e0b\u67e5\u8be2\uff1a<\/p>\n<pre><code class=\"language-sql\">WITH RECURSIVE cte AS (\n    SELECT uuid, name, parent_uuid,name AS full_path FROM sqlbook_sqlbook1.navigator_navigation  \n    WHERE category='SQL' \n    and uuid in (select UUID from sqlbook_sqlbook1.sqlbook_file where UPPER(CONTENT) like '%EMP_HOLO%')\n\n    UNION all\n\n    SELECT t.uuid, t.name, t.parent_uuid ,CONCAT(t.name,'\/',cte.full_path ) AS full_path FROM  sqlbook_sqlbook1.navigator_navigation t\n    JOIN cte\n    ON t.uuid = cte.parent_uuid\n)\nSELECT full_path FROM cte \nwhere parent_uuid='-';<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/05\/image-1716801994875.png\" alt=\"file\" \/><\/p>\n<p>\u4ece\u622a\u56fe\u53ef\u4ee5\u770b\u5230full_path\u4e3a\u5305\u542bsqlbook\u6587\u4ef6\u540d\u7684\u5b8c\u6574\u76ee\u5f55\u6811\u7ed3\u6784\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 \u672c\u6587\u4e3b\u8981\u4ecb\u7ecd\uff0c\u5982\u4f55\u6839\u636esql\u4e2d\u7684\u5173\u952e\u5b57\uff0c\u6392\u67e5\u51fa\u54ea\u4e9b\u76ee\u5f55\u6811\u4e0b\u7684sql\u6587\u4ef6\u5728\u4f7f\u7528\u3002 \u6d4b\u8bd5\u7248\u672c\uff1astudi ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=13115\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[],"class_list":["post-13115","post","type-post","status-publish","format-standard","hentry","category-configuration"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/13115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13115"}],"version-history":[{"count":3,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/13115\/revisions"}],"predecessor-version":[{"id":13147,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/13115\/revisions\/13147"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}