{"id":2605,"date":"2022-08-15T21:28:18","date_gmt":"2022-08-15T13:28:18","guid":{"rendered":"https:\/\/wordpress.cine.idv.tw\/?p=2605"},"modified":"2022-08-16T09:33:15","modified_gmt":"2022-08-16T01:33:15","slug":"best-practice-sql-pattern-for-importing-data-into-other-tables","status":"publish","type":"post","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/","title":{"rendered":"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5de5\u4f5c\u4e0a\u5e38\u5e38\u63a5\u89f8\u5230\u8cc7\u6599\u532f\u5165\u7684\u4f5c\u696d\uff0c \u9762\u5c0d\u4e0d\u540c\u5718\u968a\u63d0\u4f9b\u7684\u8cc7\u6599\u8907\u88fd SQL \u6307\u4ee4\u7a3f\u6642\uff0c \u4e0d\u6642\u6703\u5c0d\u5718\u968a\u6210\u54e1\u7684\u5275\u610f\u7522\u751f\u656c\u4f69\u4e4b\u610f\u3002 \u5176\u4e2d\u6709\u4e9b\u5275\u610f\u5f88\u5bb9\u6613\u7406\u89e3\uff0c \u66f4\u591a\u6642\u5019\u662f\u5b8c\u5168\u4e0d\u7406\u89e3\u5275\u610f\u4e2d\u7684\u660e\u767d\uff0c \u5be6\u969b\u57f7\u884c SQL \u6307\u4ee4\u7a3f\u6642\uff0c \u4e5f\u5e38\u5e38\u78b0\u5230\u9375\u503c\u91cd\u8907\u7684\u932f\u8aa4\uff0c \u5176\u5be6\u532f\u5165\u8cc7\u6599\u7684 SQL \u6307\u4ee4\u662f\u6709\u7279\u5b9a\u7684\u6a19\u6e96\u53e5\u578b\u53ef\u4ee5\u4f7f\u7528\uff0c \u53ef\u4ee5\u5728\u5718\u968a\u6210\u54e1\u4e4b\u9593\u63a8\u5ee3\uff0c \u5167\u5316\u4e4b\u5f8c\u64da\u4ee5\u4f5c\u70ba\u6700\u4f73\u5be6\u52d9\u4f86\u61c9\u7528\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">NOT EXISTS \u6a19\u6e96\u53e5\u578b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u82e5\u5c07\u8cc7\u6599\u532f\u5165\u7c21\u5316\u70ba\uff0c \u5c07 A, B \u4f86\u6e90\u8cc7\u6599\u8868\u4e2d\u4e4b\u8cc7\u6599\uff0c \u532f\u5165 C \u76ee\u6a19\u8cc7\u6599\u8868\u4e2d\uff0c \u90a3\u9ebc\u6211\u5011\u53ef\u4ee5\u628a\u8cc7\u6599\u532f\u5165\u7684 SQL \u6307\u4ee4\u8868\u793a\u70ba:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>INSERT INTO <\/strong>C (C.FIELDs, ...)\n&nbsp;&nbsp;&nbsp; <strong>SELECT <\/strong>&#91;A|B].FIELDS, ...\n&nbsp;&nbsp;&nbsp; <strong>FROM&nbsp;&nbsp; <\/strong>A <strong>INNER JOIN <\/strong>B <strong>ON <\/strong>A.KEYs = B.KEYs\n&nbsp;&nbsp;&nbsp; <strong>WHERE&nbsp; <\/strong>...\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>AND NOT EXISTS <\/strong>(<strong>SELECT <\/strong>* <strong>FROM <\/strong>C <strong>WHERE <\/strong>C.KEYs = &#91;A|B].FIELDs)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u53ea\u8981\u53cd\u8986\u61c9\u7528\u719f\u7df4\u9019\u500b\u53e5\u578b\uff0c \u65e5\u5f8c\u78b0\u5230\u8cc7\u6599\u532f\u5165\u3001\u8907\u88fd\u3001\u642c\u79fb\u7b49\u76f8\u95dc\u5de5\u4f5c\u6642\uff0c \u5c31\u7d55\u5c0d\u4e0d\u6703\u56e0\u70ba\u5929\u99ac\u884c\u7a7a\u7684\u5275\u610f\uff0c \u800c\u5beb\u51fa\u4ee4\u4eba\u4f69\u670d\u5230\u4e94\u9ad4\u6295\u5730\uff0c \u4e26\u4e14\u9084\u57f7\u884c\u932f\u8aa4\u7684 SQL \u6307\u4ee4\u7a3f\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5de5\u4f5c\u4e0a\u5e38\u5e38\u63a5\u89f8\u5230\u8cc7\u6599\u532f\u5165\u7684\u4f5c\u696d\uff0c \u9762\u5c0d\u4e0d\u540c\u5718\u968a\u63d0\u4f9b\u7684\u8cc7\u6599\u8907\u88fd SQL \u6307\u4ee4\u7a3f\u6642\uff0c \u4e0d\u6642\u6703\u5c0d\u5718\u968a\u6210\u54e1\u7684\u5275\u610f\u7522\u751f\u656c\u4f69\u4e4b\u610f\u3002 \u5176\u4e2d\u6709\u4e9b\u5275\u610f\u5f88\u5bb9\u6613\u7406\u89e3\uff0c \u66f4\u591a\u6642\u5019\u662f\u5b8c\u5168\u4e0d\u7406\u89e3\u5275\u610f\u4e2d\u7684\u660e\u767d\uff0c \u5be6\u969b\u57f7\u884c SQL \u6307\u4ee4\u7a3f\u6642\uff0c \u4e5f\u5e38\u5e38\u78b0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2609,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":false,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[13],"tags":[54],"class_list":["post-2605","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-it","tag-sql"],"featured_image_src":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/08\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg","author_info":{"display_name":"shortie","author_link":"https:\/\/wordpress.cine.idv.tw\/index.php\/author\/shortie\/"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\" \/>\n<meta property=\"og:description\" content=\"\u5de5\u4f5c\u4e0a\u5e38\u5e38\u63a5\u89f8\u5230\u8cc7\u6599\u532f\u5165\u7684\u4f5c\u696d\uff0c \u9762\u5c0d\u4e0d\u540c\u5718\u968a\u63d0\u4f9b\u7684\u8cc7\u6599\u8907\u88fd SQL \u6307\u4ee4\u7a3f\u6642\uff0c \u4e0d\u6642\u6703\u5c0d\u5718\u968a\u6210\u54e1\u7684\u5275\u610f\u7522\u751f\u656c\u4f69\u4e4b\u610f\u3002 \u5176\u4e2d\u6709\u4e9b\u5275\u610f\u5f88\u5bb9\u6613\u7406\u89e3\uff0c \u66f4\u591a\u6642\u5019\u662f\u5b8c\u5168\u4e0d\u7406\u89e3\u5275\u610f\u4e2d\u7684\u660e\u767d\uff0c \u5be6\u969b\u57f7\u884c SQL \u6307\u4ee4\u7a3f\u6642\uff0c \u4e5f\u5e38\u5e38\u78b0 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-15T13:28:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-16T01:33:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/08\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"580\" \/>\n\t<meta property=\"og:image:height\" content=\"90\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"shortie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005:\" \/>\n\t<meta name=\"twitter:data1\" content=\"shortie\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9810\u4f30\u95b1\u8b80\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\u9418\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/\"},\"author\":{\"name\":\"shortie\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#\\\/schema\\\/person\\\/2f7c8d7d06c31412a22aeeeb557c791f\"},\"headline\":\"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b\",\"datePublished\":\"2022-08-15T13:28:18+00:00\",\"dateModified\":\"2022-08-16T01:33:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/\"},\"wordCount\":11,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#\\\/schema\\\/person\\\/2f7c8d7d06c31412a22aeeeb557c791f\"},\"image\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg\",\"keywords\":[\"SQL\"],\"articleSection\":[\"\u8cc7\u8a0a\u79d1\u6280\"],\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/\",\"url\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/\",\"name\":\"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg\",\"datePublished\":\"2022-08-15T13:28:18+00:00\",\"dateModified\":\"2022-08-16T01:33:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg\",\"contentUrl\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg\",\"width\":580,\"height\":90},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2022\\\/08\\\/15\\\/best-practice-sql-pattern-for-importing-data-into-other-tables\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9801\",\"item\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#website\",\"url\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/\",\"name\":\"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\",\"description\":\"\u656c\u754f\u8036\u548c\u83ef\u662f\u667a\u6167\u7684\u958b\u7aef\uff0c \u8a8d\u8b58\u81f3\u8056\u8005\u4fbf\u662f\u8070\u660e\u3002\u7bb4\u8a00\u4e5d:10\",\"publisher\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#\\\/schema\\\/person\\\/2f7c8d7d06c31412a22aeeeb557c791f\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-TW\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#\\\/schema\\\/person\\\/2f7c8d7d06c31412a22aeeeb557c791f\",\"name\":\"shortie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/i2.wp.com\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/111945_400x400.jpg?fit=400%2C400&ssl=1\",\"url\":\"https:\\\/\\\/i2.wp.com\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/111945_400x400.jpg?fit=400%2C400&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i2.wp.com\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/111945_400x400.jpg?fit=400%2C400&ssl=1\",\"width\":400,\"height\":400,\"caption\":\"shortie\"},\"logo\":{\"@id\":\"https:\\\/\\\/i2.wp.com\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/111945_400x400.jpg?fit=400%2C400&ssl=1\"},\"sameAs\":[\"https:\\\/\\\/wordpress.cine.idv.tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/","og_locale":"zh_TW","og_type":"article","og_title":"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","og_description":"\u5de5\u4f5c\u4e0a\u5e38\u5e38\u63a5\u89f8\u5230\u8cc7\u6599\u532f\u5165\u7684\u4f5c\u696d\uff0c \u9762\u5c0d\u4e0d\u540c\u5718\u968a\u63d0\u4f9b\u7684\u8cc7\u6599\u8907\u88fd SQL \u6307\u4ee4\u7a3f\u6642\uff0c \u4e0d\u6642\u6703\u5c0d\u5718\u968a\u6210\u54e1\u7684\u5275\u610f\u7522\u751f\u656c\u4f69\u4e4b\u610f\u3002 \u5176\u4e2d\u6709\u4e9b\u5275\u610f\u5f88\u5bb9\u6613\u7406\u89e3\uff0c \u66f4\u591a\u6642\u5019\u662f\u5b8c\u5168\u4e0d\u7406\u89e3\u5275\u610f\u4e2d\u7684\u660e\u767d\uff0c \u5be6\u969b\u57f7\u884c SQL \u6307\u4ee4\u7a3f\u6642\uff0c \u4e5f\u5e38\u5e38\u78b0 [&hellip;]","og_url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/","og_site_name":"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","article_published_time":"2022-08-15T13:28:18+00:00","article_modified_time":"2022-08-16T01:33:15+00:00","og_image":[{"width":580,"height":90,"url":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/08\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg","type":"image\/jpeg"}],"author":"shortie","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005:":"shortie","\u9810\u4f30\u95b1\u8b80\u6642\u9593":"1 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/#article","isPartOf":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/"},"author":{"name":"shortie","@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f"},"headline":"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b","datePublished":"2022-08-15T13:28:18+00:00","dateModified":"2022-08-16T01:33:15+00:00","mainEntityOfPage":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/"},"wordCount":11,"commentCount":0,"publisher":{"@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f"},"image":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/08\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg","keywords":["SQL"],"articleSection":["\u8cc7\u8a0a\u79d1\u6280"],"inLanguage":"zh-TW","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/","url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/","name":"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","isPartOf":{"@id":"https:\/\/wordpress.cine.idv.tw\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/#primaryimage"},"image":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/08\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg","datePublished":"2022-08-15T13:28:18+00:00","dateModified":"2022-08-16T01:33:15+00:00","breadcrumb":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/"]}]},{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/#primaryimage","url":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/08\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg","contentUrl":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/08\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg","width":580,"height":90},{"@type":"BreadcrumbList","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/08\/15\/best-practice-sql-pattern-for-importing-data-into-other-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/wordpress.cine.idv.tw\/"},{"@type":"ListItem","position":2,"name":"SQL: \u8cc7\u6599\u532f\u5165\u4ed6\u65b9\u8cc7\u6599\u8868\u7684\u6a19\u6e96\u53e5\u578b"}]},{"@type":"WebSite","@id":"https:\/\/wordpress.cine.idv.tw\/#website","url":"https:\/\/wordpress.cine.idv.tw\/","name":"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","description":"\u656c\u754f\u8036\u548c\u83ef\u662f\u667a\u6167\u7684\u958b\u7aef\uff0c \u8a8d\u8b58\u81f3\u8056\u8005\u4fbf\u662f\u8070\u660e\u3002\u7bb4\u8a00\u4e5d:10","publisher":{"@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wordpress.cine.idv.tw\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-TW"},{"@type":["Person","Organization"],"@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f","name":"shortie","image":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/i2.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/111945_400x400.jpg?fit=400%2C400&ssl=1","url":"https:\/\/i2.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/111945_400x400.jpg?fit=400%2C400&ssl=1","contentUrl":"https:\/\/i2.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/111945_400x400.jpg?fit=400%2C400&ssl=1","width":400,"height":400,"caption":"shortie"},"logo":{"@id":"https:\/\/i2.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/111945_400x400.jpg?fit=400%2C400&ssl=1"},"sameAs":["https:\/\/wordpress.cine.idv.tw"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/08\/sql-import-data-with-not-exists-2022-08-16_08-21-46.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2GqAF-G1","jetpack-related-posts":[{"id":2752,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2023\/01\/01\/shortie-s-best-csv-editor-rons-csv-editor\/","url_meta":{"origin":2605,"position":0},"title":"2023 \u6700\u4f73 CSV \u7de8\u8f2f\u5668\uff1a Rons CSV Editor (Shortie&#8217;s Best 2023)","author":"shortie","date":"2023-01-01","format":false,"excerpt":"\u6211\u8a66\u7528\u904e\u5f88\u591a CSV \u6a94\u6848\u7684\u7de8\u8f2f\u5668\u3001\u8f49\u63db\u5668\uff0c\u4f46\u662f\u82e5\u8981\u8aaa\u5230\u4e00\u500b\u53ef\u4ee5\u61c9\u4ed8\u6240\u6709 CSV \u683c\u5f0f\u7684\u7de8\u8f2f\u5668\uff0c\u90a3\u9ebc\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2068,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/11\/07\/how-to-flush-write-cache-in-microsoft-windows\/","url_meta":{"origin":2605,"position":1},"title":"\u8a72\u600e\u9ebc\u624b\u52d5\u8b93 Microsoft Windows \u4f5c\u696d\u7cfb\u7d71\u6e05\u7a7a\u6a94\u6848\u7cfb\u7d71\u5feb\u53d6?","author":"shortie","date":"2021-11-07","format":false,"excerpt":"\u4f5c\u696d\u7cfb\u7d71\u4e2d\u7684\u6a94\u6848\u7cfb\u7d71\uff0c \u901a\u5e38\u4f7f\u7528 Buffered I\/O \u8655\u7406\u4f4d\u65bc\u5916\u90e8\u5be6\u9ad4\u786c\u789f\u4e0a\u4e4b\u8cc7\u6599\uff0c Micr\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/2021-11-07_10-37-57-sync-write-volumecache.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/2021-11-07_10-37-57-sync-write-volumecache.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/2021-11-07_10-37-57-sync-write-volumecache.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/2021-11-07_10-37-57-sync-write-volumecache.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":464,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2018\/09\/08\/tableau-create-date-calculated-field\/","url_meta":{"origin":2605,"position":2},"title":"\u5728 Tableau \u4e2d\u5229\u7528\u6587\u5b57\u6b04\u4f4d\u5efa\u7acb\u65e5\u671f\u5c0e\u51fa\u6b04\u4f4d","author":"shortie","date":"2018-09-08","format":false,"excerpt":"shortie \u7d93\u624b\u7684\u5404\u5f0f\u8cc7\u6599\u4e2d\uff0c\u7d93\u5e38\u6703\u78b0\u5230\u4f86\u6e90\u8cc7\u6599\u4e2d\u7684\u65e5\u671f\u6642\u9593\u6b04\u4f4d\uff0c\u88ab\u62c6\u89e3\u70ba\u5e74\u3001\u6708\u3001\u65e5\u3001\u6642\u3001\u5206\u3001\u79d2\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3033,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2015\/07\/28\/git-version-control-system\/","url_meta":{"origin":2605,"position":3},"title":"Git Version Control System","author":"shortie","date":"2015-07-28","format":false,"excerpt":"Git \u662f\u76ee\u524d\u81ea\u5df1\u6700\u5e38\u4f7f\u7528\u7684\u7248\u672c\u63a7\u5236\uff08\u7ba1\u7406\uff09\u7cfb\u7d71 (VCS, Version Control Sys\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1842,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/12\/examples-of-disputes-in-taiwan-government-official-document-writingg\/","url_meta":{"origin":2605,"position":4},"title":"\u516c\u6587\u66f8\u5beb\u7684\u722d\u8b70\u7bc4\u4f8b","author":"shortie","date":"2021-08-12","format":false,"excerpt":"\u4eca\u5929\u5728 Line \u7684\u4e0d\u540c\u7fa4\u7d44\u4e4b\u9593\uff0c\u6536\u5230\u591a\u6b21\u865f\u7a31\u662f\u884c\u653f\u9662\u884c\u6587\u8ca1\u653f\u90e8\u7684\u516c\u6587\u5716\u6a94 (\u53c3\u898b\u4e0b\u5716) \uff0c\u914d\u5408\u8073\u52d5\u2026","rel":"","context":"\u5728\u300c\u751f\u6d3b\u300d\u4e2d","block_context":{"text":"\u751f\u6d3b","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/life\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/%E8%A1%8C%E6%94%BF%E9%99%A2%E5%85%AC%E6%96%87%E9%95%B7%E9%81%94-17-%E8%A1%8C.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/%E8%A1%8C%E6%94%BF%E9%99%A2%E5%85%AC%E6%96%87%E9%95%B7%E9%81%94-17-%E8%A1%8C.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/%E8%A1%8C%E6%94%BF%E9%99%A2%E5%85%AC%E6%96%87%E9%95%B7%E9%81%94-17-%E8%A1%8C.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/%E8%A1%8C%E6%94%BF%E9%99%A2%E5%85%AC%E6%96%87%E9%95%B7%E9%81%94-17-%E8%A1%8C.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/%E8%A1%8C%E6%94%BF%E9%99%A2%E5%85%AC%E6%96%87%E9%95%B7%E9%81%94-17-%E8%A1%8C.jpg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":1218,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/","url_meta":{"origin":2605,"position":5},"title":"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2","author":"shortie","date":"2020-12-31","format":false,"excerpt":"2020 \u5e74\u6700\u5f8c\u4e00\u5929, \u516c\u53f8\u65bd\u884c\u5fb7\u653f\u4e0b\u5348\u4e0d\u4e0a\u73ed, \u6b63\u5728\u4eab\u53d7\u96e3\u5f97\u4e0d\u7528\u6025\u6025\u5fd9\u5fd9\u63a5\u9001\u5c0f\u5b69\u7684\u6642\u5149, \u51b7\u4e0d\u9632\u6536\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/2605","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/comments?post=2605"}],"version-history":[{"count":3,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/2605\/revisions"}],"predecessor-version":[{"id":2608,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/2605\/revisions\/2608"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/media\/2609"}],"wp:attachment":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/media?parent=2605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/categories?post=2605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/tags?post=2605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}