{"id":1218,"date":"2020-12-31T17:52:42","date_gmt":"2020-12-31T09:52:42","guid":{"rendered":"https:\/\/wordpress.cine.idv.tw\/?p=1218"},"modified":"2021-01-01T11:14:09","modified_gmt":"2021-01-01T03:14:09","slug":"mysql-auto-increment-column-gap-2","status":"publish","type":"post","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/","title":{"rendered":"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">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\u5230\u540c\u5b78\u5728 Line \u7684\u53e6\u4e00\u908a\u5288\u982d\u5c31\u554f, \u4ed6\u7684\u516c\u53f8\u8edf\u9ad4\u5718\u968a\u767c\u73fe, MySQL \u8cc7\u6599\u5eab\u4e2d\u6709\u5f88\u591a\u4f7f\u7528 AUTO_INCREMENT \u6b04\u4f4d\u7684\u8cc7\u6599\u8868, \u51fa\u73fe\u4e2d\u65b7\u6578\u842c\u865f\u7684\u60c5\u6cc1. \u56e0\u70ba\u4ed6\u4e0b\u8f44\u7684\u5718\u968a\u6210\u54e1\u6709\u4eba\u96e2\u8077\u65e5\u671f\u662f\u4eca\u5929, \u4ed6\u641e\u4e0d\u6e05\u695a\u5230\u5e95\u662f\u6b63\u5e38\u7684\u201c\u8df3\u865f\u201d, \u9084\u662f\u4e0a\u6f14\u4e86\u88ab\u522a\u5eab\u8dd1\u8def\u7684\u6232\u78bc, \u56e0\u6b64\u8981\u6211\u5e6b\u5fd9\u77a7\u77a7\u600e\u9ebc\u56de\u4e8b.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6211\u8acb\u4ed6\u628a\u5718\u968a\u4e2d\u5178\u578b\u7684\u8cc7\u6599\u7dad\u8b77\u7a0b\u5f0f\u50b3\u4e00\u652f\u7d66\u6211\u77a7\u77a7\u5148, \u5728\u5176\u4e2d\u767c\u73fe\u7a0b\u5f0f\u4f7f\u7528\u4e86\u5927\u91cf\u7684 INSERT &#8230; ON DUPLICATE KEY UPDATE \u6558\u8ff0, \u7531\u65bc\u5148\u524d\u5f88\u5c11\u770b\u5230\u8edf\u9ad4\u958b\u767c\u5718\u968a\u6703\u7528\u9019\u6558\u8ff0\u4f86\u53d6\u4ee3\u50b3\u7d71\u7684 \bUPDATE \u6558\u8ff0, \u6240\u4ee5\u5148\u53bb MySQL \u5b98\u7db2\u4e2d\u7ffb\u95b1 INSERT &#8230; ON DUPLICATE KEY UPDATE \u7684\u6587\u4ef6, \u624d\u770b\u5230\u7b2c\u4e8c\u6bb5\u6587\u5b57, \u99ac\u4e0a\u5c31\u89ba\u5f97\u597d\u50cf\u602a\u602a\u7684\u5594&#8230;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"440\" data-attachment-id=\"1224\" data-permalink=\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/2020-12-31_17-48-06\/\" data-orig-file=\"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?fit=614%2C440&amp;ssl=1\" data-orig-size=\"614,440\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2020-12-31_17-48-06\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?fit=300%2C215&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?fit=614%2C440&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?resize=614%2C440&#038;ssl=1\" alt=\"\" class=\"wp-image-1224\" srcset=\"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?w=614&amp;ssl=1 614w, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?resize=300%2C215&amp;ssl=1 300w, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?resize=230%2C165&amp;ssl=1 230w, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?resize=350%2C251&amp;ssl=1 350w, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?resize=480%2C344&amp;ssl=1 480w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><figcaption>\u91dd\u5c0d AUTO_INCREMENT \u6b04\u4f4d\u7684\u8655\u7406, UPDATE \u8207 INSERT &#8230; ON DUPLICATE KEY UPDATE \u5169\u8005\u5f88\u4e0d\u76f8\u540c.<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4e0b\u8acb\u540c\u5b78\u518d\u50b3\u7a0b\u5f0f\u4f7f\u7528\u7684 DDL \u7d66\u6211\u77a7\u77a7,  \u7acb\u523b\u5c31\u767c\u73fe\u554f\u984c\u6240\u5728\u56c9, \u56e0\u6b64\u8acb\u540c\u5b78\u53ef\u4ee5\u7a0d\u5fae\u653e\u5fc3, \u9019\u8cc7\u6599\u5eab\u4e2d\u7684\u8cc7\u6599\u767c\u751f\u8df3\u865f\u7684\u60c5\u6cc1, \u6709\u53ef\u80fd\u4e0d\u662f\u96e2\u8077\u54e1\u5de5\u522a\u5eab\u8dd1\u8def\u6240\u9020\u6210\u7684. \u540c\u6642\u5beb\u4e86\u500b Appliction Note \u7d66\u4ed6, \u8acb\u4ed6\u767c\u7d66\u4ed6\u7684\u5718\u968a\u53c3\u8003, \u66f4\u65b0\u8cc7\u6599\u8868\u4e2d\u7684\u8cc7\u6599, \u591a\u6578\u60c5\u6cc1\u7528 UPDATE \u6558\u8ff0\u5c31\u5920\u4e86, \bINSERT &#8230; ON DUPLICATE KEY UPDATE \u6558\u8ff0\u61c9\u8a72\u53ea\u5728\u975e\u4e0d\u5f97\u5df2\u7684\u60c5\u6cc1\u4e4b\u4e0b\u624d\u53bb\u4f7f\u7528 (\u4ec0\u9ebc\u60c5\u6cc1\u7b97\u662f\u975e\u4e0d\u5f97\u5df2\u7684\u60c5\u6cc1\u5462\uff1f *_*).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Application Note<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"> USE playground;\n\n DROP TABLE IF EXISTS t1;\n\n CREATE TABLE t1\n (\n     f_id    int NOT NULL AUTO_INCREMENT,\n     f_ak1   int NOT NULL,\n     f_ak2   int NOT NULL,\n     f_value int NOT NULL,\n     PRIMARY KEY (f_id),\n     UNIQUE INDEX idx_f_unique (f_ak1, f_ak2)\n ) ENGINE = InnoDB;\n\n INSERT INTO t1 (f_ak1, f_ak2, f_value)\n VALUES (1, 1, 1),\n        (2, 2, 2);\n\n SELECT f_id, f_ak1, f_ak2, f_value FROM t1;\n \/*\n ** Result Grid:\n **\n **      |f_id       |f_ak1      |f_ak2      |f_value    |\n **      |-----------|-----------|-----------|-----------|\n **      |1          |1          |1          |1          |\n **      |2          |2          |2          |2          |\n *\/\n\n -- Create a gap, 3\n INSERT INTO t1 (f_ak1, f_ak2, f_value)\n VALUES (1, 1, 1)\n     ON DUPLICATE KEY UPDATE f_ak1   = VALUES(f_ak1),\n                             f_ak2   = VALUES(f_ak2),\n                             f_value = VALUES(f_value) * 10 + VALUES(f_value);\n\n INSERT INTO t1 (f_ak1, f_ak2, f_value) VALUES (3, 3, 3);\n\n -- Create another gap, 5\n INSERT INTO t1 (f_ak1, f_ak2, f_value)\n VALUES (3, 3, 3)\n     ON DUPLICATE KEY UPDATE f_ak1   = VALUES(f_ak1),\n                             f_ak2   = VALUES(f_ak2),\n                             f_value = VALUES(f_value) * 10 + VALUES(f_value);\n\n INSERT INTO t1 (f_ak1, f_ak2, f_value) VALUES (4, 4, 4);\n\n SELECT f_id, f_ak1, f_ak2, f_value FROM t1;\n \/*\n ** Result Grid:\n **\n **      |f_id       |f_ak1      |f_ak2      |f_value    |\n **      |-----------|-----------|-----------|-----------|\n **      |1          |1          |1          |11         |\n **      |2          |2          |2          |2          |\n **      |4          |3          |3          |33         |\n **      |6          |4          |4          |4          |\n *\/\n\n DROP TABLE IF EXISTS t1;<\/pre>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/AN20201231.txt\">AN20201231<\/a><a href=\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/AN20201231.txt\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u5efa\u8b70\u4e8b\u9805<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\u52ff\u5c0d MySQL \u7684\u81ea\u52d5\u7de8\u865f\u6b04\u4f4d\u4e2d\u7684\u6578\u503c, \u62b1\u6709\u5176\u4e2d\u4e4b\u503c\u662f\u9023\u7e8c\u7684\u8aa4\u89e3.<\/li><li>\u76e1\u91cf\u5c11\u7528 INSERT &#8230; ON DUPLICATE KEY UPDATE \u6558\u8ff0, \u5c24\u5176\u662f\u5728 SA\/SD \u4f7f\u7528\u81ea\u52d5\u7de8\u865f\u6b04\u4f4d\u4e4b\u8cc7\u6599\u8868\u7684\u7dad\u8b77\u7a0b\u5f0f\u4e2d.<\/li><li>\u81ea\u52d5\u7de8\u865f\u6b04\u4f4d\u4e2d\u7684\u6578\u503c\u7522\u751f\u8df3\u865f\u7684\u60c5\u6cc1\u662f\u975e\u5e38\u6b63\u5e38\u7684\u60c5\u6cc1, \u4e0d\u9700\u8981\u7279\u5225\u64d4\u5fc3, \u66f4\u4e0d\u8981\u628a\u9019\u7a2e\u6b04\u4f4d\u61c9\u7528\u5728\u9700\u8981\u7522\u751f\u9023\u7e8c\u8cc7\u6599\u7684\u5546\u696d\u61c9\u7528\u4e2d.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u53c3\u8003\u8cc7\u6599<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/insert-on-duplicate.html\">INSERT &#8230; ON DUPLICATE KEY UPDATE Statement<\/a><\/li><li><a href=\"https:\/\/wordpress.cine.idv.tw\/index.php\/2019\/03\/30\/mysql-auto-increment-column-gap-1\/\">MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u9996\u90e8\u66f2<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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\u5230\u540c\u5b78\u5728 Line \u7684\u53e6\u4e00\u908a\u5288\u982d\u5c31\u554f, \u4ed6\u7684\u516c\u53f8\u8edf\u9ad4\u5718\u968a\u767c\u73fe, MySQL \u8cc7\u6599\u5eab\u4e2d\u6709\u5f88\u591a\u4f7f\u7528 AUTO_INCREME [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":true,"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":[25,54],"class_list":["post-1218","post","type-post","status-publish","format-standard","hentry","category-it","tag-mysql","tag-sql"],"featured_image_src":null,"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 v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2 - \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\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\" \/>\n<meta property=\"og:description\" content=\"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\u5230\u540c\u5b78\u5728 Line \u7684\u53e6\u4e00\u908a\u5288\u982d\u5c31\u554f, \u4ed6\u7684\u516c\u53f8\u8edf\u9ad4\u5718\u968a\u767c\u73fe, MySQL \u8cc7\u6599\u5eab\u4e2d\u6709\u5f88\u591a\u4f7f\u7528 AUTO_INCREME [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/\" \/>\n<meta property=\"og:site_name\" content=\"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-31T09:52:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-01T03:14:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png\" \/>\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\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/\"},\"author\":{\"name\":\"shortie\",\"@id\":\"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f\"},\"headline\":\"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2\",\"datePublished\":\"2020-12-31T09:52:42+00:00\",\"dateModified\":\"2021-01-01T03:14:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/\"},\"wordCount\":57,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f\"},\"image\":{\"@id\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png\",\"keywords\":[\"MySQL\",\"SQL\"],\"articleSection\":[\"\u8cc7\u8a0a\u79d1\u6280\"],\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/\",\"url\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/\",\"name\":\"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\",\"isPartOf\":{\"@id\":\"https:\/\/wordpress.cine.idv.tw\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png\",\"datePublished\":\"2020-12-31T09:52:42+00:00\",\"dateModified\":\"2021-01-01T03:14:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?fit=614%2C440&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?fit=614%2C440&ssl=1\",\"width\":614,\"height\":440},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9801\",\"item\":\"https:\/\/wordpress.cine.idv.tw\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2\"}]},{\"@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:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/image\/\",\"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:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/wordpress.cine.idv.tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2 - \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\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/","og_locale":"zh_TW","og_type":"article","og_title":"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","og_description":"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\u5230\u540c\u5b78\u5728 Line \u7684\u53e6\u4e00\u908a\u5288\u982d\u5c31\u554f, \u4ed6\u7684\u516c\u53f8\u8edf\u9ad4\u5718\u968a\u767c\u73fe, MySQL \u8cc7\u6599\u5eab\u4e2d\u6709\u5f88\u591a\u4f7f\u7528 AUTO_INCREME [&hellip;]","og_url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/","og_site_name":"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","article_published_time":"2020-12-31T09:52:42+00:00","article_modified_time":"2021-01-01T03:14:09+00:00","og_image":[{"url":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png","type":"","width":"","height":""}],"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\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#article","isPartOf":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/"},"author":{"name":"shortie","@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f"},"headline":"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2","datePublished":"2020-12-31T09:52:42+00:00","dateModified":"2021-01-01T03:14:09+00:00","mainEntityOfPage":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/"},"wordCount":57,"commentCount":1,"publisher":{"@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f"},"image":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#primaryimage"},"thumbnailUrl":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png","keywords":["MySQL","SQL"],"articleSection":["\u8cc7\u8a0a\u79d1\u6280"],"inLanguage":"zh-TW","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/","url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/","name":"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","isPartOf":{"@id":"https:\/\/wordpress.cine.idv.tw\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#primaryimage"},"image":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#primaryimage"},"thumbnailUrl":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png","datePublished":"2020-12-31T09:52:42+00:00","dateModified":"2021-01-01T03:14:09+00:00","breadcrumb":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/"]}]},{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#primaryimage","url":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?fit=614%2C440&ssl=1","contentUrl":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-31_17-48-06.png?fit=614%2C440&ssl=1","width":614,"height":440},{"@type":"BreadcrumbList","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/31\/mysql-auto-increment-column-gap-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/wordpress.cine.idv.tw\/"},{"@type":"ListItem","position":2,"name":"MySQL AUTO_INCREMENT \u6703 \u201c\u8df3\u865f\u201d \u4e8c\u90e8\u66f2"}]},{"@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:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/image\/","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:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/wordpress.cine.idv.tw"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2GqAF-jE","jetpack-related-posts":[{"id":601,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2019\/03\/30\/mysql-auto-increment-column-gap-1\/","url_meta":{"origin":1218,"position":0},"title":"MySQL AUTO_INCREMENT \u6703 &#8220;\u8df3\u865f&#8221; \u9996\u90e8\u66f2","author":"shortie","date":"2019-03-30","format":false,"excerpt":"\u5076\u723e\u958b\u767c\u4eba\u54e1\u6703\u88ab\u81ea\u52d5\u7de8\u865f\u6b04\u4f4d\u8df3\u865f\u7684\u73fe\u8c61\u8aa4\u5c0e, \u5c07\u5176\u89e3\u91cb\u70ba\u7a0b\u5f0f\u6709\u5beb\u5165\u8cc7\u6599\u5eab, \u4f46\u662f\u88ab\u8cc7\u6599\u5eab\u628a\u8cc7\u6599\u7d66\u641e\u4e1f\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\/2019\/03\/2019-03-30_01-40-54-1.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2019\/03\/2019-03-30_01-40-54-1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2019\/03\/2019-03-30_01-40-54-1.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1187,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/12\/19\/powerdesigner-jdbc-mysql-could-not-load-class-com-mysql-jdbc-driver\/","url_meta":{"origin":1218,"position":1},"title":"PowerDesigner \u4f7f\u7528 JDBC \u9023\u7dda MySQL \u51fa\u73fe Could not load class com.mysql.jdbc.Driver \u932f\u8aa4\u7684\u89e3\u6c7a\u65b9\u6848","author":"shortie","date":"2020-12-19","format":false,"excerpt":"\u65e9\u5148\u5728 PowerDesigner \u4e2d, \u6b32\u4f7f\u7528 JDBC \u9023\u7dda MySQL \u6642, \u7576\u4e0b\u4e0d\u7ba1\u600e\u9ebc\u8a2d\u5b9a\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-19_02-29-17-1.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-19_02-29-17-1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-19_02-29-17-1.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2020\/12\/2020-12-19_02-29-17-1.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":988,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2020\/06\/03\/aws-rds-mysql-many-connection-errors\/","url_meta":{"origin":1218,"position":2},"title":"AWS RDS MySQL \u56e0\u70ba [HY000][1129] many connection errors \u932f\u8aa4\u5c0e\u81f4\u7121\u6cd5\u9023\u7dda\uff0c\u8a72\u600e\u9ebc\u8fa6?","author":"shortie","date":"2020-06-03","format":false,"excerpt":"\u4e0d\u7ba1\u662f\u56e0\u70ba\u8a2d\u5b9a\u932f\u8aa4\u3001\u7a0b\u5f0f\u932f\u8aa4\u3001\u8cc7\u5b89\u554f\u984c\u7b49\u7a2e\u7a2e\u56e0\u7d20\u6240\u5c0e\u81f4\uff0c\u7121\u6cd5\u9023\u7dda\u5230\u4f7f\u7528\u4e2d\u7684 MySQL \u8cc7\u6599\u5eab\uff0c\u5c0d\u4efb\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\/06\/mysql-many-connection-errors-2020-06-04_10-18-40.png?fit=447%2C404&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":498,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2018\/11\/11\/mysql-alter-procedure-for-real-deal\/","url_meta":{"origin":1218,"position":3},"title":"MySQL \u4fee\u6539\u9810\u5b58\u7a0b\u5e8f\u7684\u53c3\u6578\u8207\u5167\u5bb9","author":"shortie","date":"2018-11-11","format":false,"excerpt":"\u9810\u5b58\u7a0b\u5e8f\u90e8\u7f72\u5230\u7dda\u4e0a\u8cc7\u6599\u5eab\u4e4b\u5f8c, \u96e3\u514d\u6703\u56e0\u70ba\u898f\u683c\u4fee\u6539, \u800c\u9700\u8981\u66f4\u52d5\u53c3\u6578\u6216\u5167\u5bb9, \u9019\u6642\u5019\u5c31\u6703\u9a5a\u559c\u5730\u767c\u73fe,\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":2487,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2022\/06\/19\/mysql-users-changed-their-ip-addresses-what-is-the-best-way-to-deal-with-this\/","url_meta":{"origin":1218,"position":4},"title":"MySQL: \u4fee\u6539\u5e33\u865f\u4f7f\u7528\u7684\u4f86\u6e90 IP \u4f4d\u5740\u53ef\u4ee5\u9019\u9ebc\u505a!","author":"shortie","date":"2022-06-19","format":false,"excerpt":"\u6211\u5011\u5b58\u53d6\u9060\u7aef\u7684 MySQL \u4f3a\u670d\u5668\u6642\uff0c \u901a\u5e38\u70ba\u4e86\u5b89\u5168\u7684\u7de3\u6545\uff0c \u9060\u7aef\u7684 MySQL \u7ba1\u7406\u4eba\u54e1\u4e0d\u592a\u53ef\u80fd\u5e6b\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\/2022\/06\/%E4%B8%80%E5%80%8B%E5%9B%BA%E5%AE%9A-IP-%E4%B8%83%E5%80%8B%E5%8B%95%E6%85%8B-IP-1-scaled.jpg?fit=1200%2C562&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/06\/%E4%B8%80%E5%80%8B%E5%9B%BA%E5%AE%9A-IP-%E4%B8%83%E5%80%8B%E5%8B%95%E6%85%8B-IP-1-scaled.jpg?fit=1200%2C562&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/06\/%E4%B8%80%E5%80%8B%E5%9B%BA%E5%AE%9A-IP-%E4%B8%83%E5%80%8B%E5%8B%95%E6%85%8B-IP-1-scaled.jpg?fit=1200%2C562&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/06\/%E4%B8%80%E5%80%8B%E5%9B%BA%E5%AE%9A-IP-%E4%B8%83%E5%80%8B%E5%8B%95%E6%85%8B-IP-1-scaled.jpg?fit=1200%2C562&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2022\/06\/%E4%B8%80%E5%80%8B%E5%9B%BA%E5%AE%9A-IP-%E4%B8%83%E5%80%8B%E5%8B%95%E6%85%8B-IP-1-scaled.jpg?fit=1200%2C562&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3033,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2015\/07\/28\/git-version-control-system\/","url_meta":{"origin":1218,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/1218","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=1218"}],"version-history":[{"count":8,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/1218\/revisions"}],"predecessor-version":[{"id":1230,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/1218\/revisions\/1230"}],"wp:attachment":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/media?parent=1218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/categories?post=1218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/tags?post=1218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}