{"id":1016,"date":"2026-07-12T14:26:20","date_gmt":"2026-07-12T14:26:20","guid":{"rendered":"https:\/\/hyc.eshachem.com\/program\/?p=1016"},"modified":"2026-07-12T14:36:37","modified_gmt":"2026-07-12T14:36:37","slug":"%e5%b0%87excel%e5%8c%af%e5%85%a5mysql","status":"publish","type":"post","link":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/","title":{"rendered":"MySQL &#8211; \u5c07Excel\u532f\u5165mySQL"},"content":{"rendered":"\n<ol class=\"wp-block-list\">\n<li>\u5275\u5efa\u597dSchema\u5f8c\u5efa\u7acb\u4e00\u500btable\uff0c\u547d\u540d\u5f8c\u4ec0\u9ebc\u90fd\u4e0d\u7528\u505a\uff0c\u76f4\u63a5apply\u5f8c\u5c07\u7a0b\u5f0f\u78bc\u5beb\u4e0a\u53bb<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">CREATE TABLE <span class=\"hljs-string\">`Schema\u540d\u7a31`<\/span>.<span class=\"hljs-string\">`Table\u540d\u7a31`<\/span> (\n    ERSBKEY VARCHAR(<span class=\"hljs-number\">255<\/span>),\n    \u540d\u7a31 VARCHAR(<span class=\"hljs-number\">255<\/span>),\n    \u79d1\u5225 VARCHAR(<span class=\"hljs-number\">255<\/span>),...\n);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p class=\"wp-block-paragraph\">1. \u5c07excel\u7684\u5167\u5bb9\u532f\u51fa\u6210csv<br><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"411\" src=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/07\/image-6.png\" alt=\"\" class=\"wp-image-1018\" srcset=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/07\/image-6.png 435w, https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/07\/image-6-300x283.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">2. \u53f3\u9375\u525b\u5275\u597d\u7684table<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"385\" height=\"202\" src=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/07\/image-1-1.png\" alt=\"\" class=\"wp-image-1019\" srcset=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/07\/image-1-1.png 385w, https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/07\/image-1-1-300x157.png 300w\" sizes=\"auto, (max-width: 385px) 100vw, 385px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. \u9078\u64c7\u597d\u6a94\u6848\u5f8c\u4e00\u76f4\u6309next\u5c31\u597d\u4e86<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"%e9%8c%af%e8%aa%a4%e8%99%95%e7%90%86\">\u932f\u8aa4\u8655\u7406<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u51fa\u73fe\u4ee5\u4e0b\u554f\u984c:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u56e0\u70ba\u6c92\u6709pk,\u6240\u4ee5\u8981\u53bb\u7d66\u4ed6pk\u7d50\u679csql\u8df3\u51fa\u4f86\u8aaa\u820a\u7684\u8cc7\u6599\u9019\u6a23\u6703\u6c92\u6709pk\uff0c\u90a3\u8a72\u600e\u9ebc\u8fa6?<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u5f88\u7c21\u55ae\uff0c\u6211\u5011\u7d66\u4ed6\u4e00\u500b\u81ea\u52d5\u88dc\u503c\u7684id\u5c31\u884c\u4e86:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">ALTER TABLE your_table\nADD COLUMN id BIGINT NOT <span class=\"hljs-keyword\">NULL<\/span> AUTO_INCREMENT;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p class=\"wp-block-paragraph\">\u518d\u628a\u4ed6\u8a2d\u70bapk<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">ALTER TABLE your_table\nADD PRIMARY KEY (id);<\/code><\/span><\/pre>\n\n\n<p class=\"wp-block-paragraph\">\u53c8\u6216\u8005\u8981\u7528\u65e2\u6709\u6b04\u4f4d\u505apk:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1-%e5%85%88%e6%aa%a2%e6%9f%a5%e6%9c%89%e6%b2%92%e6%9c%89%e9%87%8d%e8%a4%87\">1. \u5148\u6aa2\u67e5\u6709\u6c92\u6709\u91cd\u8907<\/h3>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">SELECT your_column,COUNT(*)\nFROM your_table\nGROUP BY your_column\nHAVING COUNT(*)&gt;1;<\/code><\/span><\/pre>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\">\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2-%e6%aa%a2%e6%9f%a5-null\">2. \u6aa2\u67e5 NULL<\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">SELECT*\nFROM your_table\nWHERE your_column IS <span class=\"hljs-keyword\">NULL<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\">\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3-%e5%86%8d%e5%8a%a0-pk\">3. \u518d\u52a0 PK<\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">ALTER TABLE your_table\nMODIFY your_column VARCHAR(<span class=\"hljs-number\">50<\/span>) NOT <span class=\"hljs-keyword\">NULL<\/span>;\n\nALTER TABLE your_table\nADD PRIMARY KEY (your_column);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>","protected":false},"excerpt":{"rendered":"<p>1. \u5c07excel\u7684\u5167\u5bb9\u532f\u51fa\u6210csv 2. \u53f3\u9375\u525b\u5275\u597d\u7684table 3. \u9078\u64c7\u597d\u6a94\u6848\u5f8c\u4e00\u76f4\u6309next\u5c31\u597d\u4e86 \u932f\u8aa4\u8655\u7406 \u5982\u679c\u51fa\u73fe\u4ee5\u4e0b\u554f\u984c: \u56e0\u70ba\u6c92\u6709pk,\u6240\u4ee5\u8981\u53bb\u7d66\u4ed6pk\u7d50\u679csql\u8df3\u51fa\u4f86\u8aaa\u820a\u7684\u8cc7\u6599\u9019\u6a23\u6703\u6c92\u6709pk\uff0c\u90a3\u8a72\u600e\u9ebc\u8fa6? \u5f88\u7c21\u55ae\uff0c\u6211\u5011\u7d66\u4ed6\u4e00\u500b\u81ea\u52d5\u88dc\u503c\u7684id\u5c31\u884c\u4e86: \u518d\u628a\u4ed6\u8a2d\u70bapk \u53c8\u6216\u8005\u8981\u7528\u65e2\u6709\u6b04\u4f4d\u505apk: 1. \u5148\u6aa2\u67e5\u6709\u6c92\u6709\u91cd\u8907 2. \u6aa2\u67e5 NULL 3. \u518d\u52a0 PK<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[39],"tags":[],"class_list":["post-1016","post","type-post","status-publish","format-standard","hentry","category-back-end"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u5275\u5efa\u597dSchema\u5f8c\u5efa\u7acb\u4e00\u500btable\uff0c\u547d\u540d\u5f8c\u4ec0\u9ebc\u90fd\u4e0d\u7528\u505a\uff0c\u76f4\u63a5apply\u5f8c\u5c07\u7a0b\u5f0f\u78bc\u5beb\u4e0a\u53bb CREATE TABLE `Schema\u540d\u7a31`.`Table\u540d\u7a31` ( ERSBKEY VARCHAR(255), \u540d\u7a31 VARCHAR(255), \u79d1\u5225 VARCHAR(255),... ); 1. \u5c07excel\u7684\u5167\u5bb9\u532f\u51fa\u6210csv 2. \u53f3\u9375\u525b\u5275\u597d\u7684table 3. \u9078\u64c7\u597d\u6a94\u6848\u5f8c\u4e00\u76f4\u6309next\u5c31\u597d\u4e86 \u932f\u8aa4\u8655\u7406 \u5982\u679c\u51fa\u73fe\u4ee5\u4e0b\u554f\u984c: \u56e0\u70ba\u6c92\u6709pk,\u6240\u4ee5\u8981\u53bb\u7d66\u4ed6pk\u7d50\u679csql\u8df3\u51fa\u4f86\u8aaa\u820a\u7684\u8cc7\u6599\u9019\u6a23\u6703\u6c92\u6709pk\uff0c\u90a3\u8a72\u600e\u9ebc\u8fa6? \u5f88\u7c21\u55ae\uff0c\u6211\u5011\u7d66\u4ed6\u4e00\u500b\u81ea\u52d5\u88dc\u503c\u7684id\u5c31\u884c\u4e86: ALTER TABLE your_table ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT; \u518d\u628a\u4ed6\u8a2d\u70bapk ALTER TABLE your_table ADD PRIMARY KEY (id); \u53c8\u6216\u8005\u8981\u7528\u65e2\u6709\u6b04\u4f4d\u505apk: 1. \u5148\u6aa2\u67e5\u6709\u6c92\u6709\u91cd\u8907 SELECT your_column,COUNT(*) FROM your_table GROUP BY your_column HAVING COUNT(*)&gt;1; 2. \u6aa2\u67e5 NULL\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"H.Y. Chen\"\/>\n\t<meta name=\"google-site-verification\" content=\"-324YR5tomynX5FeTW2lTMHIX0KmPBvpxjXpOhXwi1Q\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"HyC Wiki - Technical articles\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MySQL \u2013 \u5c07Excel\u532f\u5165mySQL - HyC Wiki\" \/>\n\t\t<meta property=\"og:description\" content=\"\u5275\u5efa\u597dSchema\u5f8c\u5efa\u7acb\u4e00\u500btable\uff0c\u547d\u540d\u5f8c\u4ec0\u9ebc\u90fd\u4e0d\u7528\u505a\uff0c\u76f4\u63a5apply\u5f8c\u5c07\u7a0b\u5f0f\u78bc\u5beb\u4e0a\u53bb CREATE TABLE `Schema\u540d\u7a31`.`Table\u540d\u7a31` ( ERSBKEY VARCHAR(255), \u540d\u7a31 VARCHAR(255), \u79d1\u5225 VARCHAR(255),... ); 1. \u5c07excel\u7684\u5167\u5bb9\u532f\u51fa\u6210csv 2. \u53f3\u9375\u525b\u5275\u597d\u7684table 3. \u9078\u64c7\u597d\u6a94\u6848\u5f8c\u4e00\u76f4\u6309next\u5c31\u597d\u4e86 \u932f\u8aa4\u8655\u7406 \u5982\u679c\u51fa\u73fe\u4ee5\u4e0b\u554f\u984c: \u56e0\u70ba\u6c92\u6709pk,\u6240\u4ee5\u8981\u53bb\u7d66\u4ed6pk\u7d50\u679csql\u8df3\u51fa\u4f86\u8aaa\u820a\u7684\u8cc7\u6599\u9019\u6a23\u6703\u6c92\u6709pk\uff0c\u90a3\u8a72\u600e\u9ebc\u8fa6? \u5f88\u7c21\u55ae\uff0c\u6211\u5011\u7d66\u4ed6\u4e00\u500b\u81ea\u52d5\u88dc\u503c\u7684id\u5c31\u884c\u4e86: ALTER TABLE your_table ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT; \u518d\u628a\u4ed6\u8a2d\u70bapk ALTER TABLE your_table ADD PRIMARY KEY (id); \u53c8\u6216\u8005\u8981\u7528\u65e2\u6709\u6b04\u4f4d\u505apk: 1. \u5148\u6aa2\u67e5\u6709\u6c92\u6709\u91cd\u8907 SELECT your_column,COUNT(*) FROM your_table GROUP BY your_column HAVING COUNT(*)&gt;1; 2. \u6aa2\u67e5 NULL\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"64\" \/>\n\t\t<meta property=\"og:image:height\" content=\"64\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-07-12T14:26:20+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-07-12T14:36:37+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MySQL \u2013 \u5c07Excel\u532f\u5165mySQL - HyC Wiki\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u5275\u5efa\u597dSchema\u5f8c\u5efa\u7acb\u4e00\u500btable\uff0c\u547d\u540d\u5f8c\u4ec0\u9ebc\u90fd\u4e0d\u7528\u505a\uff0c\u76f4\u63a5apply\u5f8c\u5c07\u7a0b\u5f0f\u78bc\u5beb\u4e0a\u53bb CREATE TABLE `Schema\u540d\u7a31`.`Table\u540d\u7a31` ( ERSBKEY VARCHAR(255), \u540d\u7a31 VARCHAR(255), \u79d1\u5225 VARCHAR(255),... ); 1. \u5c07excel\u7684\u5167\u5bb9\u532f\u51fa\u6210csv 2. \u53f3\u9375\u525b\u5275\u597d\u7684table 3. \u9078\u64c7\u597d\u6a94\u6848\u5f8c\u4e00\u76f4\u6309next\u5c31\u597d\u4e86 \u932f\u8aa4\u8655\u7406 \u5982\u679c\u51fa\u73fe\u4ee5\u4e0b\u554f\u984c: \u56e0\u70ba\u6c92\u6709pk,\u6240\u4ee5\u8981\u53bb\u7d66\u4ed6pk\u7d50\u679csql\u8df3\u51fa\u4f86\u8aaa\u820a\u7684\u8cc7\u6599\u9019\u6a23\u6703\u6c92\u6709pk\uff0c\u90a3\u8a72\u600e\u9ebc\u8fa6? \u5f88\u7c21\u55ae\uff0c\u6211\u5011\u7d66\u4ed6\u4e00\u500b\u81ea\u52d5\u88dc\u503c\u7684id\u5c31\u884c\u4e86: ALTER TABLE your_table ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT; \u518d\u628a\u4ed6\u8a2d\u70bapk ALTER TABLE your_table ADD PRIMARY KEY (id); \u53c8\u6216\u8005\u8981\u7528\u65e2\u6709\u6b04\u4f4d\u505apk: 1. \u5148\u6aa2\u67e5\u6709\u6c92\u6709\u91cd\u8907 SELECT your_column,COUNT(*) FROM your_table GROUP BY your_column HAVING COUNT(*)&gt;1; 2. \u6aa2\u67e5 NULL\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#blogposting\",\"name\":\"MySQL \\u2013 \\u5c07Excel\\u532f\\u5165mySQL - HyC Wiki\",\"headline\":\"MySQL &#8211; \\u5c07Excel\\u532f\\u5165mySQL\",\"author\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/image-6.png\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#articleImage\",\"width\":435,\"height\":411},\"datePublished\":\"2026-07-12T14:26:20+00:00\",\"dateModified\":\"2026-07-12T14:36:37+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#webpage\"},\"articleSection\":\"Back-End\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/category\\\/back-end\\\/#listItem\",\"name\":\"Back-End\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/category\\\/back-end\\\/#listItem\",\"position\":2,\"name\":\"Back-End\",\"item\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/category\\\/back-end\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#listItem\",\"name\":\"MySQL &#8211; \\u5c07Excel\\u532f\\u5165mySQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#listItem\",\"position\":3,\"name\":\"MySQL &#8211; \\u5c07Excel\\u532f\\u5165mySQL\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/category\\\/back-end\\\/#listItem\",\"name\":\"Back-End\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#person\",\"name\":\"H.Y. Chen\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"H.Y. Chen\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/#author\",\"url\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/\",\"name\":\"H.Y. Chen\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"H.Y. Chen\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#webpage\",\"url\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/\",\"name\":\"MySQL \\u2013 \\u5c07Excel\\u532f\\u5165mySQL - HyC Wiki\",\"description\":\"\\u5275\\u5efa\\u597dSchema\\u5f8c\\u5efa\\u7acb\\u4e00\\u500btable\\uff0c\\u547d\\u540d\\u5f8c\\u4ec0\\u9ebc\\u90fd\\u4e0d\\u7528\\u505a\\uff0c\\u76f4\\u63a5apply\\u5f8c\\u5c07\\u7a0b\\u5f0f\\u78bc\\u5beb\\u4e0a\\u53bb CREATE TABLE `Schema\\u540d\\u7a31`.`Table\\u540d\\u7a31` ( ERSBKEY VARCHAR(255), \\u540d\\u7a31 VARCHAR(255), \\u79d1\\u5225 VARCHAR(255),... ); 1. \\u5c07excel\\u7684\\u5167\\u5bb9\\u532f\\u51fa\\u6210csv 2. \\u53f3\\u9375\\u525b\\u5275\\u597d\\u7684table 3. \\u9078\\u64c7\\u597d\\u6a94\\u6848\\u5f8c\\u4e00\\u76f4\\u6309next\\u5c31\\u597d\\u4e86 \\u932f\\u8aa4\\u8655\\u7406 \\u5982\\u679c\\u51fa\\u73fe\\u4ee5\\u4e0b\\u554f\\u984c: \\u56e0\\u70ba\\u6c92\\u6709pk,\\u6240\\u4ee5\\u8981\\u53bb\\u7d66\\u4ed6pk\\u7d50\\u679csql\\u8df3\\u51fa\\u4f86\\u8aaa\\u820a\\u7684\\u8cc7\\u6599\\u9019\\u6a23\\u6703\\u6c92\\u6709pk\\uff0c\\u90a3\\u8a72\\u600e\\u9ebc\\u8fa6? \\u5f88\\u7c21\\u55ae\\uff0c\\u6211\\u5011\\u7d66\\u4ed6\\u4e00\\u500b\\u81ea\\u52d5\\u88dc\\u503c\\u7684id\\u5c31\\u884c\\u4e86: ALTER TABLE your_table ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT; \\u518d\\u628a\\u4ed6\\u8a2d\\u70bapk ALTER TABLE your_table ADD PRIMARY KEY (id); \\u53c8\\u6216\\u8005\\u8981\\u7528\\u65e2\\u6709\\u6b04\\u4f4d\\u505apk: 1. \\u5148\\u6aa2\\u67e5\\u6709\\u6c92\\u6709\\u91cd\\u8907 SELECT your_column,COUNT(*) FROM your_table GROUP BY your_column HAVING COUNT(*)>1; 2. \\u6aa2\\u67e5 NULL\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/#author\"},\"datePublished\":\"2026-07-12T14:26:20+00:00\",\"dateModified\":\"2026-07-12T14:36:37+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#website\",\"url\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/\",\"name\":\"HyC Wiki\",\"description\":\"Technical articles\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MySQL \u2013 \u5c07Excel\u532f\u5165mySQL - HyC Wiki","description":"\u5275\u5efa\u597dSchema\u5f8c\u5efa\u7acb\u4e00\u500btable\uff0c\u547d\u540d\u5f8c\u4ec0\u9ebc\u90fd\u4e0d\u7528\u505a\uff0c\u76f4\u63a5apply\u5f8c\u5c07\u7a0b\u5f0f\u78bc\u5beb\u4e0a\u53bb CREATE TABLE `Schema\u540d\u7a31`.`Table\u540d\u7a31` ( ERSBKEY VARCHAR(255), \u540d\u7a31 VARCHAR(255), \u79d1\u5225 VARCHAR(255),... ); 1. \u5c07excel\u7684\u5167\u5bb9\u532f\u51fa\u6210csv 2. \u53f3\u9375\u525b\u5275\u597d\u7684table 3. \u9078\u64c7\u597d\u6a94\u6848\u5f8c\u4e00\u76f4\u6309next\u5c31\u597d\u4e86 \u932f\u8aa4\u8655\u7406 \u5982\u679c\u51fa\u73fe\u4ee5\u4e0b\u554f\u984c: \u56e0\u70ba\u6c92\u6709pk,\u6240\u4ee5\u8981\u53bb\u7d66\u4ed6pk\u7d50\u679csql\u8df3\u51fa\u4f86\u8aaa\u820a\u7684\u8cc7\u6599\u9019\u6a23\u6703\u6c92\u6709pk\uff0c\u90a3\u8a72\u600e\u9ebc\u8fa6? \u5f88\u7c21\u55ae\uff0c\u6211\u5011\u7d66\u4ed6\u4e00\u500b\u81ea\u52d5\u88dc\u503c\u7684id\u5c31\u884c\u4e86: ALTER TABLE your_table ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT; \u518d\u628a\u4ed6\u8a2d\u70bapk ALTER TABLE your_table ADD PRIMARY KEY (id); \u53c8\u6216\u8005\u8981\u7528\u65e2\u6709\u6b04\u4f4d\u505apk: 1. \u5148\u6aa2\u67e5\u6709\u6c92\u6709\u91cd\u8907 SELECT your_column,COUNT(*) FROM your_table GROUP BY your_column HAVING COUNT(*)>1; 2. \u6aa2\u67e5 NULL","canonical_url":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"-324YR5tomynX5FeTW2lTMHIX0KmPBvpxjXpOhXwi1Q","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#blogposting","name":"MySQL \u2013 \u5c07Excel\u532f\u5165mySQL - HyC Wiki","headline":"MySQL &#8211; \u5c07Excel\u532f\u5165mySQL","author":{"@id":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/#author"},"publisher":{"@id":"https:\/\/hyc.eshachem.com\/program\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/07\/image-6.png","@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#articleImage","width":435,"height":411},"datePublished":"2026-07-12T14:26:20+00:00","dateModified":"2026-07-12T14:36:37+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#webpage"},"isPartOf":{"@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#webpage"},"articleSection":"Back-End"},{"@type":"BreadcrumbList","@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program#listItem","position":1,"name":"Home","item":"https:\/\/hyc.eshachem.com\/program","nextItem":{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/#listItem","name":"Back-End"}},{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/#listItem","position":2,"name":"Back-End","item":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/","nextItem":{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#listItem","name":"MySQL &#8211; \u5c07Excel\u532f\u5165mySQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#listItem","position":3,"name":"MySQL &#8211; \u5c07Excel\u532f\u5165mySQL","previousItem":{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/#listItem","name":"Back-End"}}]},{"@type":"Person","@id":"https:\/\/hyc.eshachem.com\/program\/#person","name":"H.Y. Chen","image":{"@type":"ImageObject","@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g","width":96,"height":96,"caption":"H.Y. Chen"}},{"@type":"Person","@id":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/#author","url":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/","name":"H.Y. Chen","image":{"@type":"ImageObject","@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g","width":96,"height":96,"caption":"H.Y. Chen"}},{"@type":"WebPage","@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#webpage","url":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/","name":"MySQL \u2013 \u5c07Excel\u532f\u5165mySQL - HyC Wiki","description":"\u5275\u5efa\u597dSchema\u5f8c\u5efa\u7acb\u4e00\u500btable\uff0c\u547d\u540d\u5f8c\u4ec0\u9ebc\u90fd\u4e0d\u7528\u505a\uff0c\u76f4\u63a5apply\u5f8c\u5c07\u7a0b\u5f0f\u78bc\u5beb\u4e0a\u53bb CREATE TABLE `Schema\u540d\u7a31`.`Table\u540d\u7a31` ( ERSBKEY VARCHAR(255), \u540d\u7a31 VARCHAR(255), \u79d1\u5225 VARCHAR(255),... ); 1. \u5c07excel\u7684\u5167\u5bb9\u532f\u51fa\u6210csv 2. \u53f3\u9375\u525b\u5275\u597d\u7684table 3. \u9078\u64c7\u597d\u6a94\u6848\u5f8c\u4e00\u76f4\u6309next\u5c31\u597d\u4e86 \u932f\u8aa4\u8655\u7406 \u5982\u679c\u51fa\u73fe\u4ee5\u4e0b\u554f\u984c: \u56e0\u70ba\u6c92\u6709pk,\u6240\u4ee5\u8981\u53bb\u7d66\u4ed6pk\u7d50\u679csql\u8df3\u51fa\u4f86\u8aaa\u820a\u7684\u8cc7\u6599\u9019\u6a23\u6703\u6c92\u6709pk\uff0c\u90a3\u8a72\u600e\u9ebc\u8fa6? \u5f88\u7c21\u55ae\uff0c\u6211\u5011\u7d66\u4ed6\u4e00\u500b\u81ea\u52d5\u88dc\u503c\u7684id\u5c31\u884c\u4e86: ALTER TABLE your_table ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT; \u518d\u628a\u4ed6\u8a2d\u70bapk ALTER TABLE your_table ADD PRIMARY KEY (id); \u53c8\u6216\u8005\u8981\u7528\u65e2\u6709\u6b04\u4f4d\u505apk: 1. \u5148\u6aa2\u67e5\u6709\u6c92\u6709\u91cd\u8907 SELECT your_column,COUNT(*) FROM your_table GROUP BY your_column HAVING COUNT(*)>1; 2. \u6aa2\u67e5 NULL","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/hyc.eshachem.com\/program\/#website"},"breadcrumb":{"@id":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/#breadcrumblist"},"author":{"@id":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/#author"},"creator":{"@id":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/#author"},"datePublished":"2026-07-12T14:26:20+00:00","dateModified":"2026-07-12T14:36:37+00:00"},{"@type":"WebSite","@id":"https:\/\/hyc.eshachem.com\/program\/#website","url":"https:\/\/hyc.eshachem.com\/program\/","name":"HyC Wiki","description":"Technical articles","inLanguage":"en-US","publisher":{"@id":"https:\/\/hyc.eshachem.com\/program\/#person"}}]},"og:locale":"en_US","og:site_name":"HyC Wiki - Technical articles","og:type":"article","og:title":"MySQL \u2013 \u5c07Excel\u532f\u5165mySQL - HyC Wiki","og:description":"\u5275\u5efa\u597dSchema\u5f8c\u5efa\u7acb\u4e00\u500btable\uff0c\u547d\u540d\u5f8c\u4ec0\u9ebc\u90fd\u4e0d\u7528\u505a\uff0c\u76f4\u63a5apply\u5f8c\u5c07\u7a0b\u5f0f\u78bc\u5beb\u4e0a\u53bb CREATE TABLE `Schema\u540d\u7a31`.`Table\u540d\u7a31` ( ERSBKEY VARCHAR(255), \u540d\u7a31 VARCHAR(255), \u79d1\u5225 VARCHAR(255),... ); 1. \u5c07excel\u7684\u5167\u5bb9\u532f\u51fa\u6210csv 2. \u53f3\u9375\u525b\u5275\u597d\u7684table 3. \u9078\u64c7\u597d\u6a94\u6848\u5f8c\u4e00\u76f4\u6309next\u5c31\u597d\u4e86 \u932f\u8aa4\u8655\u7406 \u5982\u679c\u51fa\u73fe\u4ee5\u4e0b\u554f\u984c: \u56e0\u70ba\u6c92\u6709pk,\u6240\u4ee5\u8981\u53bb\u7d66\u4ed6pk\u7d50\u679csql\u8df3\u51fa\u4f86\u8aaa\u820a\u7684\u8cc7\u6599\u9019\u6a23\u6703\u6c92\u6709pk\uff0c\u90a3\u8a72\u600e\u9ebc\u8fa6? \u5f88\u7c21\u55ae\uff0c\u6211\u5011\u7d66\u4ed6\u4e00\u500b\u81ea\u52d5\u88dc\u503c\u7684id\u5c31\u884c\u4e86: ALTER TABLE your_table ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT; \u518d\u628a\u4ed6\u8a2d\u70bapk ALTER TABLE your_table ADD PRIMARY KEY (id); \u53c8\u6216\u8005\u8981\u7528\u65e2\u6709\u6b04\u4f4d\u505apk: 1. \u5148\u6aa2\u67e5\u6709\u6c92\u6709\u91cd\u8907 SELECT your_column,COUNT(*) FROM your_table GROUP BY your_column HAVING COUNT(*)&gt;1; 2. \u6aa2\u67e5 NULL","og:url":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/","og:image":"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png","og:image:secure_url":"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png","og:image:width":64,"og:image:height":64,"article:published_time":"2026-07-12T14:26:20+00:00","article:modified_time":"2026-07-12T14:36:37+00:00","twitter:card":"summary_large_image","twitter:title":"MySQL \u2013 \u5c07Excel\u532f\u5165mySQL - HyC Wiki","twitter:description":"\u5275\u5efa\u597dSchema\u5f8c\u5efa\u7acb\u4e00\u500btable\uff0c\u547d\u540d\u5f8c\u4ec0\u9ebc\u90fd\u4e0d\u7528\u505a\uff0c\u76f4\u63a5apply\u5f8c\u5c07\u7a0b\u5f0f\u78bc\u5beb\u4e0a\u53bb CREATE TABLE `Schema\u540d\u7a31`.`Table\u540d\u7a31` ( ERSBKEY VARCHAR(255), \u540d\u7a31 VARCHAR(255), \u79d1\u5225 VARCHAR(255),... ); 1. \u5c07excel\u7684\u5167\u5bb9\u532f\u51fa\u6210csv 2. \u53f3\u9375\u525b\u5275\u597d\u7684table 3. \u9078\u64c7\u597d\u6a94\u6848\u5f8c\u4e00\u76f4\u6309next\u5c31\u597d\u4e86 \u932f\u8aa4\u8655\u7406 \u5982\u679c\u51fa\u73fe\u4ee5\u4e0b\u554f\u984c: \u56e0\u70ba\u6c92\u6709pk,\u6240\u4ee5\u8981\u53bb\u7d66\u4ed6pk\u7d50\u679csql\u8df3\u51fa\u4f86\u8aaa\u820a\u7684\u8cc7\u6599\u9019\u6a23\u6703\u6c92\u6709pk\uff0c\u90a3\u8a72\u600e\u9ebc\u8fa6? \u5f88\u7c21\u55ae\uff0c\u6211\u5011\u7d66\u4ed6\u4e00\u500b\u81ea\u52d5\u88dc\u503c\u7684id\u5c31\u884c\u4e86: ALTER TABLE your_table ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT; \u518d\u628a\u4ed6\u8a2d\u70bapk ALTER TABLE your_table ADD PRIMARY KEY (id); \u53c8\u6216\u8005\u8981\u7528\u65e2\u6709\u6b04\u4f4d\u505apk: 1. \u5148\u6aa2\u67e5\u6709\u6c92\u6709\u91cd\u8907 SELECT your_column,COUNT(*) FROM your_table GROUP BY your_column HAVING COUNT(*)&gt;1; 2. \u6aa2\u67e5 NULL","twitter:image":"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png"},"aioseo_meta_data":{"post_id":"1016","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-07-28 14:33:05","updated":"2026-07-28 14:33:05"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/hyc.eshachem.com\/program\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/\" title=\"Back-End\">Back-End<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMySQL \u2013 \u5c07Excel\u532f\u5165mySQL\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/hyc.eshachem.com\/program"},{"label":"Back-End","link":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/"},{"label":"MySQL &#8211; \u5c07Excel\u532f\u5165mySQL","link":"https:\/\/hyc.eshachem.com\/program\/%e5%b0%87excel%e5%8c%af%e5%85%a5mysql\/"}],"views":18,"_links":{"self":[{"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/posts\/1016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/comments?post=1016"}],"version-history":[{"count":3,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/posts\/1016\/revisions"}],"predecessor-version":[{"id":1030,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/posts\/1016\/revisions\/1030"}],"wp:attachment":[{"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/media?parent=1016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/categories?post=1016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/tags?post=1016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}