{"id":1145,"date":"2017-05-11T15:44:31","date_gmt":"2017-05-11T07:44:31","guid":{"rendered":"http:\/\/www.baishitou.cn\/?p=1145"},"modified":"2020-09-22T14:37:56","modified_gmt":"2020-09-22T06:37:56","slug":"%e7%bb%87%e6%a2%a6%ef%bc%88dedecms%ef%bc%89%e6%89%b9%e9%87%8f%e6%9b%bf%e6%8d%a2%e6%96%87%e7%ab%a0%e6%a0%87%e9%a2%98%e5%85%b3%e9%94%ae%e5%ad%97%e6%a0%87%e7%ad%be%e7%ad%89%e7%ad%89%e5%86%85%e5%ae%b9","status":"publish","type":"post","link":"https:\/\/www.baishitou.cn\/1145.html","title":{"rendered":"\u7ec7\u68a6\uff08DEDECMS\uff09\u6279\u91cf\u66ff\u6362\u6587\u7ae0,\u6807\u9898,\u5173\u952e\u5b57,\u6807\u7b7e\u7b49\u7b49\u5185\u5bb9\u7684SQL\u547d\u4ee4"},"content":{"rendered":"

\u6807\u9898\u6279\u91cf\u66ff\u6362<\/p>\n

update dede_archives set title=replace\uff08title,'\u65e7\u6807\u9898','\u65b0\u6807\u9898'\uff09<\/p>\n

\u6587\u7ae0\u4f5c\u8005\u6279\u91cf\u66ff\u6362<\/p>\n

update dede_archives set writer=replace\uff08writer,'\u65e7\u4f5c\u8005','\u65b0\u4f5c\u8005'\uff09<\/p>\n

\u6587\u7ae0\u6765\u6e90\u6279\u91cf\u66ff\u6362<\/p>\n

update dede_archives set source=replace\uff08source,'\u65e7\u6765\u6e90','\u65b0\u6765\u6e90'\uff09\uff1b<\/p>\n

\u6587\u7ae0\u6807\u7b7e\u6279\u91cf\u66ff\u6362<\/p>\n

update dede_tagindex set tag=replace\uff08tag,'\u65e7\u5173\u952e\u5b57','\u65b0\u5173\u952e\u5b57'\uff09\uff1b<\/p>\n

update dede_taglist set tag=replace\uff08tag,'\u65e7\u6807\u7b7e','\u65b0\u6807\u7b7e'\uff09\uff1b<\/p>\n

\u6587\u7ae0\u9875\u5173\u952e\u5b57\u6279\u91cf\u66ff\u6362<\/p>\n

update dede_archives set keywords=replace\uff08keywords,'\u522b\u4eba\u7684','\u4f60\u7684'\uff09\uff1b<\/p>\n

\u6587\u7ae0\u9875\u63cf\u8ff0\u6279\u91cf\u66ff\u6362<\/p>\n

update dede_archives set description=replace\uff08description,'\u65e7\u63cf\u8ff0','\u65b0\u63cf\u8ff0'\uff09<\/p>\n

\u6587\u7ae0Url\u89c4\u5219\u6279\u91cf\u66ff\u6362<\/p>\n

\uff08\u628a\u6240\u6709\u6587\u7ae0Url\u89c4\u5219\u5168\u90e8\u66ff\u6362\u6210{typedir}\/{aid}.html\u8fd9\u6837\u4e00\u79cd\u5f62\u5f0f\uff09<\/p>\n

update dede_arctype set namerule='{typedir}\/{aid}.html';<\/p>\n

\u5185\u5bb9\u6279\u91cf\u66ff\u6362<\/p>\n

update dede_addonarticle set body=replace\uff08body,'\u65e7\u5185\u5bb9','\u65b0\u5185\u5bb9'\uff09<\/p>\n

\u7f29\u7565\u56fe\u6279\u91cf\u66ff\u6362<\/p>\n

update dede_archives set litpic=replace\uff08litpic,'\u65e7\u56fe\u5730\u5740','\u65b0\u56fe\u5730\u5740'\uff09<\/p>\n

DeDeCMS \u6e05\u7a7a\u6240\u6709\u6587\u7ae0SQL\u8bed\u53e5<\/p>\n

DELETE FROM dede_addonarticle WHERE aid >= 1 and aid< =5000;DELETE FROM dede_arctiny WHERE id >= 1 and id< =5000;DELETE FROM dede_archives WHERE id >= 1 and id<=5000;<\/p>\n

\u6ce8\u610f\uff1a\u6e05\u7a7a\u56de\u6536\u7ad9\u91cc\u6240\u6709\u7684\u6587\u7ae0<\/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'<\/p>\n

 <\/p>\n

\u7ec7\u68a6\u6279\u91cf\u5220\u9664\u6587\u7ae0\u5185\u5bb9\u6570\u636e\u5e93\u91cc\u6240\u6709\u8d85\u94fe\u63a5<\/h1>\n

\u6ce8\u610f\uff1a\u8bb0\u5f97\u5148\u5907\u4efd\u4e00\u4e0b\u6570\u636e\u5e93<\/strong><\/p>\n

\u540e\u53f0-\u7cfb\u7edf-SQL\uff0c\u6267\u884c\u591a\u51e0\u6b21 \u4e0b\u97622\u4e2a\u8bed\u53e5\u4e00\u8d77\u6267\u884c\u591a\u6b21<\/p>\n

update #@__addonarticle set body=replace(body,substring(body,locate('<a',body),locate('>',body,locate('<a ', body))+1-locate('<a',body)),'');\r\nupdate #@__addonarticle set body=replace(body,'<\/a>','');<\/code><\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u6807\u9898\u6279\u91cf\u66ff\u6362 update dede_archives set title=replace\uff08title,'\u65e7\u6807 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[43,321,322],"class_list":["post-1145","post","type-post","status-publish","format-standard","hentry","category-web","tag-dedecms","tag-sql","tag-322"],"_links":{"self":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/posts\/1145","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=1145"}],"version-history":[{"count":0,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/posts\/1145\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/media?parent=1145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/categories?post=1145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/tags?post=1145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}