{"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"],"_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}]}}