{"id":361,"date":"2009-03-03T09:43:57","date_gmt":"2009-03-03T09:43:57","guid":{"rendered":"http:\/\/kuki.idv.tw\/blog\/?p=361"},"modified":"2009-03-03T09:43:57","modified_gmt":"2009-03-03T09:43:57","slug":"phpmyadmin%e8%b3%87%e6%96%99%e5%bf%ab%e9%80%9f%e5%8c%af%e5%85%a5%e6%96%b9%e5%bc%8f","status":"publish","type":"post","link":"https:\/\/www.kuki.idv.tw\/?p=361","title":{"rendered":"phpMyAdmin\u8cc7\u6599\u5feb\u901f\u532f\u5165\u65b9\u5f0f"},"content":{"rendered":"<p>\u6709\u5728\u4f7f\u7528\u8cc7\u6599\u5eab\u7a0b\u5f0f\u7684\u4eba\u4e00\u5b9a\u90fd\u6703\u9047\u5230\u4e00\u500b\u554f\u984c<\/p>\n<p>\u5c31\u662f\u5927\u91cf\u8cc7\u6599\u7684\u532f\u5165\u61c9\u8a72\u8981\u600e\u9ebc\u505a?<\/p>\n<p>\u5e78\u597dphpMyAdmin\u6709\u500b\u4eba\u6027\u8a71\u7684\u8a2d\u8a08,\u80fd\u5920\u4f7f\u7528\u532f\u5165\u7684\u65b9\u5f0f\u5c07\u8cc7\u6599\u7d66\u532f\u5165<\/p>\n<p>\u5c11\u53bb\u8f38\u5165\u7684\u9ebb\u7169.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignleft size-full wp-image-363\" title=\"20090303172503734\" src=\"http:\/\/kuki.idv.tw\/blog\/wp-content\/uploads\/2009\/03\/20090303172503734.png\" alt=\"20090303172503734\" width=\"746\" height=\"281\" \/><\/p>\n<p>\u00a0<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignleft size-full wp-image-364\" title=\"20090303172509921\" src=\"http:\/\/kuki.idv.tw\/blog\/wp-content\/uploads\/2009\/03\/20090303172509921.png\" alt=\"20090303172509921\" width=\"729\" height=\"287\" \/><\/p>\n<p>\u532f\u5165\u7684\u65b9\u5f0f\u6709\u5169\u7a2e,\u4e00\u7a2e\u662fSQL,\u4e00\u7a2e\u662fCSV<\/p>\n<p>\u82e5\u5f9ephpMyAdmin\u76f4\u63a5\u532f\u51fa\u7684\u8cc7\u6599\u662f\u4f7f\u7528SQL\u532f\u5165<\/p>\n<p>\u4f46\u82e5\u662f\u5f9e\u7db2\u8def\u4e0a\u6293\u5230\u7684\u8868\u683c\u60f3\u8981\u7528SQL\u532f\u5165\u6050\u6015\u5f97\u8cbb\u4e00\u7ffb\u5de5\u592b<\/p>\n<p>\u4e0d\u5982\u8f49\u63db\u6210CSV\u5427.<\/p>\n<p>\u4e00\u822cCSV\u6a94\u6848\u662f &#8220;\u6b04\u4f4d1&#8243;,&#8221;\u6b04\u4f4d2&#8243;,&#8221;\u6b04\u4f4d3&#8243;&#8230;..<\/p>\n<p>\u96d9\u5f15\u865f\u6846\u4f4f\u6b04\u4f4d\u5167\u5bb9,\u9017\u865f\u5c07\u6b04\u4f4d\u5206\u958b<\/p>\n<p>\u4f46\u662f,\u82e5\u5167\u5bb9\u4e2d\u6709\u96d9\u5f15\u865f\u600e\u9ebc\u8fa6,ex.&#8221; a&#8221;bc&#8221;<\/p>\n<p>\u4e0a\u8ff0\u7684\u4f8b\u5b50\u662f\u8981\u53d6a\u9084\u662f\u53d6bc,\u76f8\u4fe1\u96fb\u8166\u4e00\u5b9a\u6703\u5224\u65b7\u932f\u8aa4,\u505c\u5728\u9019\u4e00\u884c<\/p>\n<p>\u4e0d\u904e\u5e78\u597dphpMyAdmin\u6709\u4e00\u500b\u8070\u660e\u7684\u65b9\u5f0f. \u53ef\u4ee5\u81ea\u5df1\u9078\u64c7\u5206\u9694\u6b04\u4f4d\u7684\u5b57\u5143\u548c\u7b26\u865f<\/p>\n<p>\u53c3\u8003\u5716.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignleft size-full wp-image-362\" title=\"20090303172146265\" src=\"http:\/\/kuki.idv.tw\/blog\/wp-content\/uploads\/2009\/03\/20090303172146265.png\" alt=\"20090303172146265\" width=\"802\" height=\"298\" \/><\/p>\n<p>\u00a0\u6709\u500b\u7279\u5225\u7684\u5c0f\u5efa\u8b70 \u5206\u9694\u7b26\u865f\u53ea\u80fd\u53d6\u4e00\u500b\u5b57\u5143 \u53ef\u4ee5\u7528 | \u6216 ` (\u5de6\u4e0a\u89d2\u86af\u8693\u7b26\u865f)\u4ee3\u66ff<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6709\u5728\u4f7f\u7528\u8cc7\u6599\u5eab\u7a0b\u5f0f\u7684\u4eba\u4e00\u5b9a\u90fd\u6703\u9047\u5230\u4e00\u500b\u554f\u984c \u5c31\u662f\u5927\u91cf\u8cc7\u6599\u7684\u532f\u5165\u61c9\u8a72\u8981\u600e\u9ebc\u505a? \u5e78\u597dphpMyAdmin\u6709\u500b\u4eba\u6027 &hellip; <a href=\"https:\/\/www.kuki.idv.tw\/?p=361\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008phpMyAdmin\u8cc7\u6599\u5feb\u901f\u532f\u5165\u65b9\u5f0f\u3009<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/361"}],"collection":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=361"}],"version-history":[{"count":1,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/361\/revisions"}],"predecessor-version":[{"id":365,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/361\/revisions\/365"}],"wp:attachment":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}