{"id":342,"date":"2021-08-24T14:00:45","date_gmt":"2021-08-24T06:00:45","guid":{"rendered":"http:\/\/www.yuan95.cn\/?p=342"},"modified":"2021-09-07T16:47:26","modified_gmt":"2021-09-07T08:47:26","slug":"%e7%bb%87%e6%a2%a6%e5%b8%b8%e7%94%a8-sql%e6%89%a7%e8%a1%8c%e4%bb%a3%e7%a0%81","status":"publish","type":"post","link":"https:\/\/www.yuan95.cn\/?p=342","title":{"rendered":"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5"},"content":{"rendered":"<h2>1\u3001\u7ec7\u68a6\u6279\u91cf\u53bb\u6389\u94fe\u63a5\u4e2da\u76ee\u5f55<\/h2>\n<p>\u4ee3\u7801\u5982\u4e0b:<\/p>\n<pre>UPDATE dede_arctype SET typedir=REPLACE(typedir,'a\/','')<\/pre>\n<p>sql\u6267\u884c\u8bed\u53e5\u754c\u9762\u5728\u7cfb\u7edf \u2014\u2014 SQL\u547d\u4ee4\u884c\u5de5\u5177\u2014\u2014\u8f93\u5165\u4e0a\u9762\u90a3\u6bb5\u4ee3\u7801\u5373\u53ef<\/p>\n<h2>2\u3001\u6279\u91cf\u53bb\u6389\u7ec7\u68a6\u6587\u7ae0\u4fdd\u5b58\u8def\u5f84\u4e2d\u7684\u5e74\u6708\u65e5<\/h2>\n<p>\u8fd0\u884c\u4e0b\u9762\u8fd9\u4e2aSQL\u547d\u4ee4\uff1a<\/p>\n<pre>update dede_arctype set namerule = replace(namerule,\"{Y}\/{M}{D}\/\",'')<\/pre>\n<p>sql\u6267\u884c\u8bed\u53e5\u754c\u9762\u5728\u7cfb\u7edf \u2014\u2014 SQL\u547d\u4ee4\u884c\u5de5\u5177\u2014\u2014\u8f93\u5165\u4e0a\u9762\u90a3\u6bb5\u4ee3\u7801\u5373\u53ef\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>3\u3001\u7ec7\u68a6\u5220\u9664\u7cfb\u7edf-\u57fa\u672c\u53c2\u6570&#8211;\u53d8\u91cf<\/h2>\n<p>\u4ee3\u7801\u5982\u4e0b:Delete FROM dede_sysconfig where varname=\u201d\u8fd9\u91cc\u5199\u53d8\u91cf\u540d\u79f0\u201d<\/p>\n<div>\u4f8b\u5982\u5220\u9664QQ\u53d8\u91cfcfg_qq \uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/div>\n<pre>Delete FROM dede_sysconfig where varname=\"cfg_qq\"<\/pre>\n<div>\u4e4b\u540e\u70b9\u51fb\u786e\u5b9a\uff0c\u6267\u884c\u6210\u529f\u540e\u3002<\/div>\n<div><\/div>\n<div>\n<h2><strong>4\u3001dede\u6279\u91cf\u5220\u9664\u6307\u5b9a\u680f\u76ee\u3001\u6307\u5b9a\u65e5\u671f\u3001\u6307\u5b9aid\u4e4b\u95f4\u7684\u6587\u7ae0\u5185\u5bb9<\/strong><\/h2>\n<p>\u8fdb\u5165\u540e\u53f0-\u70b9\u51fb\u7cfb\u7edf-SQL\u547d\u4ee4\u884c\u5de5\u5177\uff0c\u51fa\u73b0\u547d\u4ee4\u884c\uff0c\u9009\u62e9\u591a\u884c\u547d\u4ee4\uff0c\u7136\u540e\u5728\u547d\u4ee4\u884c\u4e2d\u8f93\u5165\uff1a<\/p>\n<div class=\"cnblogs_Highlighter sh-gutter\">\n<div>\n<div id=\"highlighter_700897\" class=\"syntaxhighlighter sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql keyword\">DELETE<\/code>\u00a0<code class=\"sql keyword\">FROM<\/code>\u00a0<code class=\"sql plain\">dede_addonarticle\u00a0<\/code><code class=\"sql keyword\">WHERE<\/code>\u00a0<code class=\"sql plain\">aid &gt;= 100\u00a0<\/code><code class=\"sql color1\">and<\/code>\u00a0<code class=\"sql plain\">aid&lt; =5000;<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql keyword\">DELETE<\/code>\u00a0<code class=\"sql keyword\">FROM<\/code>\u00a0<code class=\"sql plain\">dede_arctiny\u00a0<\/code><code class=\"sql keyword\">WHERE<\/code>\u00a0<code class=\"sql plain\">id &gt;= 100\u00a0<\/code><code class=\"sql color1\">and<\/code>\u00a0<code class=\"sql plain\">id&lt; =5000;<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql keyword\">DELETE<\/code>\u00a0<code class=\"sql keyword\">FROM<\/code>\u00a0<code class=\"sql plain\">dede_archives\u00a0<\/code><code class=\"sql keyword\">WHERE<\/code>\u00a0<code class=\"sql plain\">id &gt;= 100\u00a0<\/code><code class=\"sql color1\">and<\/code>\u00a0<code class=\"sql plain\">id&lt;=5000;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u4e0b\u9762\u6211\u4eec\u4ecb\u7ecd\u4e0b\u5220\u9664\u4e00\u6761\u7684\u547d\u4ee4\uff1a \u5220\u9664id3389<\/p>\n<p>DELETE FROM wx_addonarticle WHERE aid = 3389;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u7ec7\u68a6\u6279\u91cf\u53bb\u6389\u94fe\u63a5\u4e2da\u76ee\u5f55 \u4ee3\u7801\u5982\u4e0b: UPDATE dede_arctype SET typedir=REPLACE(typedir,&#8217;a\/&#8217;,&#8221;) sql\u6267\u884c\u8bed\u53e5\u754c\u9762\u5728\u7cfb\u7edf \u2014\u2014 SQL\u547d\u4ee4\u884c\u5de5\u5177\u2014\u2014\u8f93\u5165\u4e0a\u9762\u90a3\u6bb5\u4ee3\u7801\u5373\u53ef 2\u3001\u6279\u91cf\u53bb&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[24],"topic":[],"class_list":["post-342","post","type-post","status-publish","format-standard","hentry","category-jianzhan","tag-zhimengjianz"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5 - \u4e50\u4e88\u535a\u5ba2<\/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.yuan95.cn\/?p=342\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5 - \u4e50\u4e88\u535a\u5ba2\" \/>\n<meta property=\"og:description\" content=\"1\u3001\u7ec7\u68a6\u6279\u91cf\u53bb\u6389\u94fe\u63a5\u4e2da\u76ee\u5f55 \u4ee3\u7801\u5982\u4e0b: UPDATE dede_arctype SET typedir=REPLACE(typedir,&#039;a\/&#039;,&#039;&#039;) sql\u6267\u884c\u8bed\u53e5\u754c\u9762\u5728\u7cfb\u7edf \u2014\u2014 SQL\u547d\u4ee4\u884c\u5de5\u5177\u2014\u2014\u8f93\u5165\u4e0a\u9762\u90a3\u6bb5\u4ee3\u7801\u5373\u53ef 2\u3001\u6279\u91cf\u53bb...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yuan95.cn\/?p=342\" \/>\n<meta property=\"og:site_name\" content=\"\u4e50\u4e88\u535a\u5ba2\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-24T06:00:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-07T08:47:26+00:00\" \/>\n<meta name=\"author\" content=\"\u9047\u5b89 \u537f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u9047\u5b89 \u537f\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/?p=342#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/?p=342\"},\"author\":{\"name\":\"\u9047\u5b89 \u537f\",\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/#\\\/schema\\\/person\\\/704c50e5d87be8b11ec69f3e0c5fd2e7\"},\"headline\":\"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5\",\"datePublished\":\"2021-08-24T06:00:45+00:00\",\"dateModified\":\"2021-09-07T08:47:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/?p=342\"},\"wordCount\":34,\"keywords\":[\"\u7ec7\u68a6\u5efa\u7ad9\"],\"articleSection\":[\"\u5efa\u7ad9\u6559\u7a0b\"],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/?p=342\",\"url\":\"https:\\\/\\\/www.yuan95.cn\\\/?p=342\",\"name\":\"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5 - \u4e50\u4e88\u535a\u5ba2\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/#website\"},\"datePublished\":\"2021-08-24T06:00:45+00:00\",\"dateModified\":\"2021-09-07T08:47:26+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/#\\\/schema\\\/person\\\/704c50e5d87be8b11ec69f3e0c5fd2e7\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/?p=342#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yuan95.cn\\\/?p=342\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/?p=342#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yuan95.cn\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/#website\",\"url\":\"https:\\\/\\\/www.yuan95.cn\\\/\",\"name\":\"\u4e50\u4e88\u535a\u5ba2\",\"description\":\"\u767e\u5ea6SEM\u7ade\u4ef7\\\/\u4fe1\u606f\u6d41\u57f9\u8bad-\u4e50\u4e88\u535a\u5ba2\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yuan95.cn\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yuan95.cn\\\/#\\\/schema\\\/person\\\/704c50e5d87be8b11ec69f3e0c5fd2e7\",\"name\":\"\u9047\u5b89 \u537f\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/www.gravatar.com\\\/avatar\\\/b3fd1e98a823f03d079b983a07c8d0cb29aa1b1aee04d9f503aea927e73aecf5?s=96&d=http:\\\/\\\/www.yuan95.cn\\\/wp-content\\\/themes\\\/dux7.2\\\/img\\\/avatar-default.png\",\"url\":\"https:\\\/\\\/www.gravatar.com\\\/avatar\\\/b3fd1e98a823f03d079b983a07c8d0cb29aa1b1aee04d9f503aea927e73aecf5?s=96&d=http:\\\/\\\/www.yuan95.cn\\\/wp-content\\\/themes\\\/dux7.2\\\/img\\\/avatar-default.png\",\"contentUrl\":\"https:\\\/\\\/www.gravatar.com\\\/avatar\\\/b3fd1e98a823f03d079b983a07c8d0cb29aa1b1aee04d9f503aea927e73aecf5?s=96&d=http:\\\/\\\/www.yuan95.cn\\\/wp-content\\\/themes\\\/dux7.2\\\/img\\\/avatar-default.png\",\"caption\":\"\u9047\u5b89 \u537f\"},\"sameAs\":[\"http:\\\/\\\/daoyan.yuan95.cn\"],\"url\":\"https:\\\/\\\/www.yuan95.cn\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5 - \u4e50\u4e88\u535a\u5ba2","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.yuan95.cn\/?p=342","og_locale":"zh_CN","og_type":"article","og_title":"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5 - \u4e50\u4e88\u535a\u5ba2","og_description":"1\u3001\u7ec7\u68a6\u6279\u91cf\u53bb\u6389\u94fe\u63a5\u4e2da\u76ee\u5f55 \u4ee3\u7801\u5982\u4e0b: UPDATE dede_arctype SET typedir=REPLACE(typedir,'a\/','') sql\u6267\u884c\u8bed\u53e5\u754c\u9762\u5728\u7cfb\u7edf \u2014\u2014 SQL\u547d\u4ee4\u884c\u5de5\u5177\u2014\u2014\u8f93\u5165\u4e0a\u9762\u90a3\u6bb5\u4ee3\u7801\u5373\u53ef 2\u3001\u6279\u91cf\u53bb...","og_url":"https:\/\/www.yuan95.cn\/?p=342","og_site_name":"\u4e50\u4e88\u535a\u5ba2","article_published_time":"2021-08-24T06:00:45+00:00","article_modified_time":"2021-09-07T08:47:26+00:00","author":"\u9047\u5b89 \u537f","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u9047\u5b89 \u537f"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yuan95.cn\/?p=342#article","isPartOf":{"@id":"https:\/\/www.yuan95.cn\/?p=342"},"author":{"name":"\u9047\u5b89 \u537f","@id":"https:\/\/www.yuan95.cn\/#\/schema\/person\/704c50e5d87be8b11ec69f3e0c5fd2e7"},"headline":"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5","datePublished":"2021-08-24T06:00:45+00:00","dateModified":"2021-09-07T08:47:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yuan95.cn\/?p=342"},"wordCount":34,"keywords":["\u7ec7\u68a6\u5efa\u7ad9"],"articleSection":["\u5efa\u7ad9\u6559\u7a0b"],"inLanguage":"zh-Hans"},{"@type":"WebPage","@id":"https:\/\/www.yuan95.cn\/?p=342","url":"https:\/\/www.yuan95.cn\/?p=342","name":"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5 - \u4e50\u4e88\u535a\u5ba2","isPartOf":{"@id":"https:\/\/www.yuan95.cn\/#website"},"datePublished":"2021-08-24T06:00:45+00:00","dateModified":"2021-09-07T08:47:26+00:00","author":{"@id":"https:\/\/www.yuan95.cn\/#\/schema\/person\/704c50e5d87be8b11ec69f3e0c5fd2e7"},"breadcrumb":{"@id":"https:\/\/www.yuan95.cn\/?p=342#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yuan95.cn\/?p=342"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.yuan95.cn\/?p=342#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yuan95.cn\/"},{"@type":"ListItem","position":2,"name":"dede\u7ec7\u68a6\u7f51\u7ad9\u5e38\u7528 sql\u6267\u884c\u8bed\u53e5"}]},{"@type":"WebSite","@id":"https:\/\/www.yuan95.cn\/#website","url":"https:\/\/www.yuan95.cn\/","name":"\u4e50\u4e88\u535a\u5ba2","description":"\u767e\u5ea6SEM\u7ade\u4ef7\/\u4fe1\u606f\u6d41\u57f9\u8bad-\u4e50\u4e88\u535a\u5ba2","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yuan95.cn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.yuan95.cn\/#\/schema\/person\/704c50e5d87be8b11ec69f3e0c5fd2e7","name":"\u9047\u5b89 \u537f","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.gravatar.com\/avatar\/b3fd1e98a823f03d079b983a07c8d0cb29aa1b1aee04d9f503aea927e73aecf5?s=96&d=http:\/\/www.yuan95.cn\/wp-content\/themes\/dux7.2\/img\/avatar-default.png","url":"https:\/\/www.gravatar.com\/avatar\/b3fd1e98a823f03d079b983a07c8d0cb29aa1b1aee04d9f503aea927e73aecf5?s=96&d=http:\/\/www.yuan95.cn\/wp-content\/themes\/dux7.2\/img\/avatar-default.png","contentUrl":"https:\/\/www.gravatar.com\/avatar\/b3fd1e98a823f03d079b983a07c8d0cb29aa1b1aee04d9f503aea927e73aecf5?s=96&d=http:\/\/www.yuan95.cn\/wp-content\/themes\/dux7.2\/img\/avatar-default.png","caption":"\u9047\u5b89 \u537f"},"sameAs":["http:\/\/daoyan.yuan95.cn"],"url":"https:\/\/www.yuan95.cn\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=\/wp\/v2\/posts\/342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=342"}],"version-history":[{"count":11,"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions"}],"predecessor-version":[{"id":422,"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions\/422"}],"wp:attachment":[{"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=342"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.yuan95.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftopic&post=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}