{"id":5624,"date":"2024-05-26T22:22:18","date_gmt":"2024-05-26T14:22:18","guid":{"rendered":"https:\/\/www.baishitou.cn\/?p=5624"},"modified":"2024-05-26T22:22:18","modified_gmt":"2024-05-26T14:22:18","slug":"%e7%bb%87%e6%a2%a6dedecms%e7%94%a8sql%e5%91%bd%e4%bb%a4%e8%a1%8c%e5%b7%a5%e5%85%b7%e6%b8%85%e7%a9%ba%e5%86%85%e5%ae%b9%e5%9b%9e%e6%94%b6%e7%ab%99","status":"publish","type":"post","link":"https:\/\/www.baishitou.cn\/5624.html","title":{"rendered":"\u7ec7\u68a6DEDECMS\u7528SQL\u547d\u4ee4\u884c\u5de5\u5177\u6e05\u7a7a\u5185\u5bb9\u56de\u6536\u7ad9"},"content":{"rendered":"

\u524d\u6bb5\u65f6\u95f4\u6279\u91cf\u5220\u9664\u4e86\u4e00\u90e8\u5206\u6587\u7ae0\uff0c\u6709\u51e0\u4e07\u6761\uff0c\u5728\u5185\u5bb9\u56de\u6536\u7ad9\u91cc\u6ca1\u6709\u7ba1\u5b83\uff0c\u4eca\u5929\u51c6\u5907\u6e05\u7a7a\u65f6\u53d1\u73b0\uff0c\u4e00\u4e0b\u4e0d\u80fd\u5168\u90e8\u6e05\u7a7a\uff0c\u53ea\u80fd\u4e00\u9875\u4e00\u9875\u7684\u6e05\u7a7a\u3002\u90a3\u5f97\u6e05\u4e86\u5565\u65f6\u5019\uff0c\u6240\u4ee5\u5c31\u627e\u5230SQL\u8bed\u53e5\uff0c\u4e00\u952e\u6e05\u7a7a\u5185\u5bb9\u56de\u6536\u7ad9\u3002\u4eb2\u6d4b\u6709\u6548<\/p>\n

\u7cfb\u7edf\u8bbe\u7f6e-SQL\u547d\u4ee4\u884c\u5de5\u5177\uff0c\u628a\u4e0b\u9762\u4ee3\u7801\u590d\u5236\u8fdb\u53bb\uff0c\u6267\u884c\u5373\u53ef\u3002<\/p>\n

delete dede_addonarticle,dede_archives,dede_arctiny from dede_addonarticle,dede_archives,dede_arctiny where dede_addonarticle.aid=dede_archives.id and dede_arctiny.id=dede_archives.id and dede_archives.arcrank='-2'<\/code><\/pre>\n

\u5982\u4e0b\u56fe\u6240\u793a<\/p>\n

\"\"<\/a><\/p>\n

\u518d\u53bb\u770b\u56de\u6536\u7ad9\uff0c\u5185\u5bb9\u6e05\u7a7a\u4e86\u3002<\/p>\n

\u5176\u5b9e\u7ec7\u68a6\u7684\u5185\u5bb9\u56de\u6536\u7ad9\u662f\u53ef\u4ee5\u5173\u95ed\u7684\u3002\u5728DedeCMS\u7cfb\u7edf\u914d\u7f6e\u53c2\u6570-\u6838\u5fc3\u8bbe\u7f6e\u91cc\u9762\uff0c\u76f4\u63a5\u5173\u95ed\uff0c\u4e0b\u6b21\u5c31\u76f4\u63a5\u5220\u9664\uff0c\u4e0d\u7528\u518d\u6e05\u7a7a\u5565\u56de\u6536\u7ad9\u4e86\u3002<\/p>\n

\"\"<\/a><\/p>\n

\u5b8c\u6bd5\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u524d\u6bb5\u65f6\u95f4\u6279\u91cf\u5220\u9664\u4e86\u4e00\u90e8\u5206\u6587\u7ae0\uff0c\u6709\u51e0\u4e07\u6761\uff0c\u5728\u5185\u5bb9\u56de\u6536\u7ad9\u91cc\u6ca1\u6709\u7ba1\u5b83\uff0c\u4eca\u5929\u51c6\u5907\u6e05\u7a7a\u65f6\u53d1\u73b0\uff0c\u4e00\u4e0b\u4e0d\u80fd\u5168\u90e8\u6e05\u7a7a\uff0c\u53ea\u80fd\u4e00\u9875 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[406,1747,180],"class_list":["post-5624","post","type-post","status-publish","format-standard","hentry","category-web","tag-sql","tag-1747","tag-180"],"_links":{"self":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/posts\/5624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/comments?post=5624"}],"version-history":[{"count":0,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/posts\/5624\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/media?parent=5624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/categories?post=5624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/tags?post=5624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}