{"id":123,"date":"2006-10-02T02:39:29","date_gmt":"2006-10-02T02:39:29","guid":{"rendered":"http:\/\/search.jason695.idv.tw:81\/wordpress\/?p=123"},"modified":"2006-10-02T02:47:48","modified_gmt":"2006-10-02T02:47:48","slug":"%e8%aa%9e%e6%84%8f%e5%b1%a4%e4%b8%ad%e6%96%87","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2006\/10\/02\/%e8%aa%9e%e6%84%8f%e5%b1%a4%e4%b8%ad%e6%96%87\/","title":{"rendered":"\u8a9e\u610f\u5c64[\u4e2d\u6587]"},"content":{"rendered":"<p><strong>\u4f55\u8b02\u8a9e\u610f\u5c64\uff1f<\/strong><\/p>\n<p>\u8a9e\u610f\u5c64\u662f\u542b\u6709\u4ee5\u4e0b\u5167\u5bb9\u7684\u6a94\u6848\uff1a<br \/>\n\u2022 \u4e00\u500b\u6216\u6578\u500b\u8cc7\u6599\u5eab\u4e2d\u4ecb\u8edf\u9ad4\u7684\u9023\u7dda\u53c3\u6578\u3002<br \/>\n\u2022 \u7a31\u70ba\u7269\u4ef6\u7684 SQL \u7d50\u69cb\uff0c\u5b83\u5011\u6703\u5c0d\u61c9\u5230\u8cc7\u6599\u5eab\u4e2d\u5be6\u969b\u7684 SQL \u7d50\u69cb (\u5982\u6b04\u3001\u8868\u683c\u548c\u8cc7\u6599\u5eab\u51fd\u6578\u7b49)\u3002<br \/>\n\u7269\u4ef6\u6703\u7fa4\u7d44\u70ba\u8a31\u591a\u7a2e\u985e\u5225\u3002Web Intelligence\u4f7f\u7528\u8005\u80fd\u540c\u6642\u770b\u5230\u7269\u4ef6\u548c\u985e\u5225\u3002<br \/>\n\u2022 \u5167\u542b\u8cc7\u6599\u5eab\u4e2d\u4f7f\u7528\u7684\u8868\u683c\u548c\u9023\u63a5\u4e4b\u7d50\u69cb\u63cf\u8ff0\u3002\u7269\u4ef6\u662f\u4f9d\u64da\u60a8\u7d50\u69cb\u63cf\u8ff0\u4e2d\u6240\u5305\u542b\u7684\u8cc7\u6599\u5eab\u7d50\u69cb\u6240\u5efa\u7acb\u7684\u3002<br \/>\n\u53ea\u6709 \u8a2d\u8a08\u8005 \u4f7f\u7528\u8005\u624d\u80fd\u4f7f\u7528\u7d50\u69cb\u63cf\u8ff0\u3002Web Intelligence \u4f7f\u7528\u8005\u770b\u4e0d\u5230\u7d50\u69cb\u63cf\u8ff0\u3002<br \/>\nWeb Intelligence \u4f7f\u7528\u8005\u6703\u9023\u63a5\u5230\u8a9e\u610f\u5c64\uff0c\u7136\u5f8c\u5c0d\u8cc7\u6599\u5eab\u57f7\u884c\u67e5\u8a62\u3002<br \/>\n\u5b83\u5011\u53ef\u4ee5\u4f7f\u7528\u8a9e\u610f\u5c64\u4e2d\u7684\u7269\u4ef6\u4f86\u9032\u884c\u8cc7\u6599\u5206\u6790\u53ca\u5efa\u7acb\u5831\u8868\uff0c<br \/>\n\u7121\u9700\u770b\u5230\u6216\u77e5\u9053\u8cc7\u6599\u5eab\u7684\u57fa\u5e95\u8cc7\u6599\u7d50\u69cb\u3002<\/p>\n<p><strong>\u8a9e\u610f\u5c64\u626e\u6f14\u4f55\u7a2e\u89d2\u8272\uff1f<br \/>\n<\/strong><br \/>\n\u8a9e\u610f\u5c64\u7684\u89d2\u8272\u662f\u63d0\u4f9b\u6613\u7528\u6613\u61c2\u7684\u4ecb\u9762\u7d66\u975e\u6280\u8853\u80cc\u666f\u7684 Web Intelligence\u4f7f\u7528\u8005\uff0c<br \/>\n\u8b93\u4ed6\u5011\u80fd\u5920\u57f7\u884c\u8cc7\u6599\u5eab\u67e5\u8a62\uff0c\u4ee5\u5efa\u7acb\u5831\u8868\u548c\u57f7\u884c\u8cc7\u6599\u5206\u6790\u3002<br \/>\n\u4f5c\u70ba\u8a9e\u610f\u5c64\u8a2d\u8a08\u8005\uff0c\u60a8\u4f7f\u7528 \u8a2d\u8a08\u8005 \u4f86\u5efa\u7acb\u4ee3\u8868\u8cc7\u6599\u5eab\u7d50\u69cb (\u4f8b\u5982\u6b04\u548c\u8cc7\u6599\u5eab\u51fd\u6578) \u7684\u7269\u4ef6\uff0c<br \/>\n\u4f7f\u7528\u8005\u5b58\u53d6\u53ca\u67e5\u8a62\u6642\u5fc5\u9808\u4f7f\u7528\u9019\u4e9b\u7269\u4ef6\u4f86\u53d6\u5f97\u696d\u52d9\u6240\u9700\u7684\u8cc7\u8a0a\u3002<br \/>\n\u60a8\u5728\u8a9e\u610f\u5c64\u6240\u5efa\u7acb\u7684\u7269\u4ef6\u5fc5\u9808\u548c\u4f7f\u7528\u8005\u5546\u52d9\u74b0\u5883\u548c\u8a5e\u5f59\u76f8\u95dc\u3002<br \/>\n\u5b83\u5011\u7684\u89d2\u8272\u662f\u5c07\u300c\u4ee5\u696d\u52d9\u70ba\u91cd\u9ede\u7684\u524d\u7aef\u300d\u5448\u73fe\u7d66\u8cc7\u6599\u5eab\u7684 SQL \u7d50\u69cb\u3002<br \/>\n\u4e0b\u5716\u986f\u793a\u5728\u8cc7\u6599\u5eab\u7d50\u69cb\u63cf\u8ff0\u548c\u5728 Web Intelligence \u4e2d\u7684 [\u67e5\u8a62] \u5de5\u4f5c\u5340\u4e4b\u9593\uff0c<br \/>\n\u7269\u4ef6\u4f5c\u70ba\u5c0d\u61c9\u5c64\u7684\u89d2\u8272\uff0c\u4f7f\u7528\u8005\u7528\u6b64\u5efa\u7acb\u5c0d\u8cc7\u6599\u5eab\u8868\u683c\u7684\u67e5\u8a62\u3002<\/p>\n<p><strong>\u8a9e\u610f\u5c64\u4e2d\u5305\u542b\u4ec0\u9ebc\uff1f<\/strong><\/p>\n<p>\u8a9e\u610f\u5c64\u5305\u542b\u4e0b\u5217\u7d50\u69cb\uff1a<br \/>\n\u2022 \u985e\u5225<br \/>\n\u2022 \u7269\u4ef6<\/p>\n<p>\u985e\u5225<\/p>\n<blockquote><p>\u985e\u5225\u662f\u8a9e\u610f\u5c64\u5167\u90e8\u7269\u4ef6\u7684\u908f\u8f2f\u5206\u7d44\u3002\u5b83\u4ee3\u8868\u67d0\u4e00\u985e\u7684\u7269\u4ef6\u3002\u985e\u5225\u540d\u7a31<br \/>\n\u5fc5\u9808\u80fd\u5920\u4ee3\u8868\u5b83\u6240\u5305\u542b\u7684\u7269\u4ef6\u4e4b\u985e\u5225\u3002\u985e\u5225\u53ef\u4ee5\u518d\u5f80\u4e0b\u7d30\u5206\u6210\u5b50\u985e\u5225\u3002<\/p><\/blockquote>\n<p>\u7269\u4ef6<\/p>\n<blockquote><p>\u7269\u4ef6\u662f\u4e00\u500b\u547d\u540d\u5143\u4ef6\uff0c\u5b83\u6703\u5c0d\u61c9\u5230\u8cc7\u6599\u5eab\u4e2d\u7684\u8cc7\u6599\u6216\u884d\u751f\u8cc7\u6599\u3002\u7269\u4ef6<br \/>\n\u540d\u7a31\u61c9\u4f86\u81ea\u76ee\u6a19\u4f7f\u7528\u8005\u7fa4\u7d44\u7684\u5546\u52d9\u8a5e\u5f59\u3002\u4f8b\u5982\uff0c\u7522\u54c1\u7d93\u7406\u4f7f\u7528\u65bc\u8a9e\u610f\u5c64\u4e2d<br \/>\n\u7684\u7269\u4ef6\u53ef\u4ee5\u662f\u7522\u54c1\u3001\u751f\u547d\u9031\u671f\u6216\u767c\u884c\u65e5\u671f\u00b0C\u800c\u8ca1\u52d9\u5206\u6790\u5e2b\u6240\u4f7f\u7528\u7684\u8a9e\u610f<br \/>\n\u5c64\uff0c\u5247\u53ef\u80fd\u5305\u542b\u908a\u969b\u5229\u6f64\u548c\u6295\u8cc7\u5831\u916c\u7b49\u7269\u4ef6\u3002<\/p><\/blockquote>\n<p><strong>\u7269\u4ef6\u985e\u578b<br \/>\n<\/strong><br \/>\n\u5728 \u8a2d\u8a08\u8005 \u4e2d\uff0c\u7269\u4ef6\u5c6c\u65bc\u4e0b\u5217\u4e09\u7a2e\u4e4b\u4e00\uff1a\u7dad\u5ea6\u3001\u8a73\u7d30\u8cc7\u6599\u6216\u8a08\u91cf\u3002<\/p>\n<ol>\n<li>\u7dad\u5ea6\u7528\u4f86\u9032\u884c\u5206\u6790\u7684\u53c3\u6578\u3002\u7dad\u5ea6\u4e00\u822c\u90fd\u548c\u968e\u5c64 (\u5982\u5730\u7406\u4f4d\u7f6e\u3001\u7522\u54c1\u6216\u6642\u9593) \u6709\u95dc\u3002\u4f8b\u5982\u59d3\u6c0f\u548c City_Id<\/li>\n<li>\u8a73\u7d30\u8cc7\u6599\u63d0\u4f9b\u7dad\u5ea6\u7684\u63cf\u8ff0\uff0c\u4f46\u5b83\u4e26\u975e\u5206\u6790\u7684\u7126\u9ede\u3002\u4f8b\u5982\u96fb\u8a71\u865f\u78bc<\/li>\n<li>\u8a08\u91cf\u8868\u9054\u6578\u5b57\u8cc7\u8a0a\uff0c\u7528\u4f86\u4ee5\u6578\u91cf\u8868\u793a\u7dad\u5ea6\u7269\u4ef6\u3002\u4f8b\u5982\u71df\u696d\u6536\u5165<\/li>\n<\/ol>\n<p><strong>\u7269\u4ef6\u6703\u63a8\u65b7\u7d50\u69cb\u63cf\u8ff0\u4e2d\u6240\u986f\u793a\u7684 SQL \u7d50\u69cb<br \/>\n<\/strong><br \/>\nWeb Intelligence \u4f7f\u7528\u8005\u5728\u8a9e\u610f\u5c64\u4e2d\u770b\u5230\u7684\u7269\u4ef6\uff0c\u6703\u63a8\u65b7\u51fa\u60a8\u5df2\u63d2\u5165\u8cc7\u6599\u5eab\u7d50\u69cb\u63cf\u8ff0\u4e2d\u7684 SQL \u7d50\u69cb\u3002<br \/>\n\u8eab\u70ba\u8a9e\u610f\u5c64\u8a2d\u8a08\u8005\uff0c\u60a8\u6703\u4f9d\u64da\u50b3\u56de\u8cc7\u6599\u6240\u9700\u7684\u8868\u683c\u548c\u9023\u63a5\u4f86\u5efa\u7acb\u6b64\u7d50\u69cb\u63cf\u8ff0\uff0c<br \/>\n\u800c\u6240\u50b3\u56de\u7684\u8cc7\u6599\u5247\u8996\u4f7f\u7528\u8005\u9032\u884c\u5206\u6790\u53ca\u5831\u8868\u5efa\u7acb\u7684\u9700\u6c42\u800c\u5b9a\u3002<br \/>\n\u7d50\u69cb\u63cf\u8ff0\u662f\u8a9e\u610f\u5c64\u6a94\u6848\u7684\u4e00\u90e8\u5206\uff0c\u4f46\u5b83\u53ea\u80fd\u5f9e \u8a2d\u8a08\u8005 \u4e2d\u770b\u5230\u53ca\u4f7f\u7528\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4f55\u8b02\u8a9e\u610f\u5c64\uff1f \u8a9e\u610f\u5c64\u662f\u542b\u6709\u4ee5\u4e0b\u5167\u5bb9\u7684\u6a94\u6848\uff1a \u2022 \u4e00\u500b\u6216\u6578\u500b\u8cc7\u6599\u5eab\u4e2d\u4ecb\u8edf\u9ad4\u7684\u9023\u7dda\u53c3\u6578\u3002 \u2022 \u7a31\u70ba\u7269\u4ef6\u7684 SQL  &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2006\/10\/02\/%e8%aa%9e%e6%84%8f%e5%b1%a4%e4%b8%ad%e6%96%87\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">\u8a9e\u610f\u5c64[\u4e2d\u6587]<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[20],"tags":[],"class_list":["post-123","post","type-post","status-publish","format-standard","hentry","category-bo","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}