{"id":1430,"date":"2013-10-27T12:36:45","date_gmt":"2013-10-27T04:36:45","guid":{"rendered":"http:\/\/blog.hoyo.idv.tw\/?p=1430"},"modified":"2017-06-08T10:30:27","modified_gmt":"2017-06-08T02:30:27","slug":"wordpress-%e7%b6%b2%e5%9d%80%e7%95%b0%e5%8b%95%ef%bc%8c%e8%b3%87%e6%96%99%e5%ba%ab%e4%bf%ae%e6%94%b9-sql-%e6%8c%87%e4%bb%a4%e8%aa%aa%e6%98%8e","status":"publish","type":"post","link":"https:\/\/blog.hoyo.idv.tw\/?p=1430","title":{"rendered":"wordpress \u7db2\u5740\u7570\u52d5\uff0c\u8cc7\u6599\u5eab\u4fee\u6539 SQL \u6307\u4ee4\u8aaa\u660e"},"content":{"rendered":"<p>wordpress \u7db2\u7ad9\u4f7f\u7528\u4e86\u65b0\u7684\u7db2\u5740\uff0c\u9664\u4e86\u672c\u8eab\u8a2d\u5b9a\u9700\u8981\u4fee\u6539\u4e4b\u5916\uff0c\u4e3b\u8981\u662f\u6587\u7ae0\u5167\u5bb9\u548c\u6a94\u6848\u9023\u7d50\u4e5f\u8981\u4e00\u4f75\u4fee\u6539\u3002<\/p>\n<p>\u4f7f\u7528 SQL \u6307\u4ee4\u4fee\u6539\u662f\u6bd4\u8f03\u5feb\u901f\u7684\u65b9\u5f0f<\/p>\n<pre class=\"lang:mysql decode:true  \">UPDATE wp_options SET option_value=REPLACE(option_value,'www.hoyo.idv.tw\/wordpress','blog.hoyo.idv.tw');\r\nUPDATE wp_posts SET post_content=REPLACE(post_content,'www.hoyo.idv.tw\/wordpress','blog.hoyo.idv.tw');\r\nUPDATE wp_posts SET guid=REPLACE(guid,'www.hoyo.idv.tw\/wordpress','blog.hoyo.idv.tw');<\/pre>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2013\/10\/20131026_000.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1431\" title=\"\" src=\"http:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2013\/10\/20131026_000.png\" alt=\"\" width=\"1001\" height=\"99\" srcset=\"https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2013\/10\/20131026_000.png 1001w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2013\/10\/20131026_000-300x29.png 300w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2013\/10\/20131026_000-1000x99.png 1000w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2013\/10\/20131026_000-500x49.png 500w\" sizes=\"(max-width: 1001px) 100vw, 1001px\" \/><\/a><\/p>\n<p>UPDATE \u8cc7\u6599\u8868\u540d\u7a31 SET \u6b04\u4f4d\u540d\u7a31=REPLACE( \u6b04\u4f4d\u540d\u7a31, '\u641c\u5c0b\u5b57\u4e32', '\u53d6\u4ee3\u65b0\u5b57\u4e32' );<\/p>\n<p>--<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p class=\"pvc_stats all \" data-element-id=\"1430\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> &nbsp;2,517&nbsp;total views<\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>wordpress \u7db2\u7ad9\u4f7f\u7528\u4e86...<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p class=\"pvc_stats all \" data-element-id=\"1430\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> &nbsp;2,517&nbsp;total views<\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[70],"tags":[140,139,71],"_links":{"self":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/1430"}],"collection":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1430"}],"version-history":[{"count":30,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/1430\/revisions"}],"predecessor-version":[{"id":3756,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/1430\/revisions\/3756"}],"wp:attachment":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}