{"id":393,"date":"2025-02-28T14:53:56","date_gmt":"2025-02-28T14:53:56","guid":{"rendered":"http:\/\/www.keshebang.com\/?p=393"},"modified":"2025-07-13T02:01:26","modified_gmt":"2025-07-13T02:01:26","slug":"%e8%bf%90%e5%8a%a8%e4%bc%9a%e7%ae%a1%e7%90%86%e7%b3%bb%e7%bb%9f%e6%95%b0%e6%8d%ae%e5%ba%93%e8%ae%be%e8%ae%a1%ef%bc%88er%e5%9b%besql%e4%bb%a3%e7%a0%81%ef%bc%89","status":"publish","type":"post","link":"http:\/\/www.keshebang.com\/?p=393","title":{"rendered":"\u8fd0\u52a8\u4f1a\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff08ER\u56fe+sql\u4ee3\u7801\uff09"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">1\u3001\u9700\u6c42\u63cf\u8ff0<\/h3>\n\n\n\n<p>\u7cfb\u7edf\u8981\u80fd\u8bb0\u5f55\u5b66\u9662\u3001\u9879\u76ee\u3001\u8fd0\u52a8\u5458\u3001\u88c1\u5224\u5458\u3001\u6bd4\u8d5b\u573a\u5730\u7b49\u57fa\u672c\u4fe1\u606f\uff1b\u80fd\u767b\u8bb0\u8fd0\u52a8\u5458\u62a5\u540d\u7684\u6bd4\u8d5b\uff1b\u80fd\u5bf9\u6bd4\u8d5b\u65e5\u7a0b\u5b89\u8fdb\u884c\u5b89\u6392\uff0c\u5305\u62ec\u6bd4\u8d5b\u7684\u65f6\u95f4\u3001\u573a\u5730\u3001\u88c1\u5224\u5458\uff1b\u80fd\u8bb0\u5f55\u6bcf\u573a\u6bd4\u8d5b\u5404\u8fd0\u52a8\u5458\u7684\u6210\u7ee9\uff1b\u5bf9\u7edf\u8ba1\u6bcf\u4e2a\u6bd4\u8d5b\u7684\u540d\u6b21\u3001\u5f97\u5206\uff1b\u80fd\u7edf\u8ba1\u5404\u5b66\u9662\u83b7\u5f97\u7684\u603b\u5206\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2\u3001ER\u56fe<\/h3>\n\n\n\n<p>\u6839\u636e\u4ee5\u4e0a\u9700\u6c42\u53ef\u4ee5\u62bd\u8c61\u51fa6\u4e2a\u5b9e\u4f53\uff1a\u5b66\u9662\u3001\u8fd0\u52a8\u5458\u3001\u88c1\u5224\u5458\u3001\u9879\u76ee\u3001\u6bd4\u8d5b\u3001\u573a\u5730\u3002<\/p>\n\n\n\n<p>\u89c4\u5219\u5047\u8bbe\uff1a\u4e00\u4e2a\u5b66\u9662\u6709\u591a\u540d\u8fd0\u52a8\u5458\uff0c\u4e00\u540d\u8fd0\u52a8\u5458\u53ea\u5c5e\u4e8e\u4e00\u4e2a\u5b66\u9662\uff1b\u4e00\u4e2a\u9879\u76ee\u53ef\u4ee5\u5b89\u6392\u591a\u573a\u6bd4\u8d5b\uff0c\u4e00\u573a\u6bd4\u8d5b\u53ea\u5c5e\u4e8e\u4e00\u4e2a\u9879\u76ee\uff1b\u4e00\u4e2a\u8fd0\u52a8\u5458\u53ef\u4ee5\u62a5\u540d\u591a\u4e2a\u6bd4\u8d5b\uff0c\u4e00\u4e2a\u6bd4\u8d5b\u53ef\u4ee5\u6709\u591a\u4e2a\u8fd0\u52a8\u5458\u548c\u88c1\u5224\uff1b\u4e00\u4e2a\u88c1\u5224\u4e5f\u53ef\u4ee5\u88c1\u51b3\u591a\u573a\u6bd4\u8d5b\uff1b\u4e00\u4e2a\u573a\u5730\u53ef\u4ee5\u5206\u7ed9\u591a\u4e2a\u6bd4\u8d5b\uff0c\u4e00\u4e2a\u6bd4\u8d5b\u53ea\u80fd\u5206\u914d\u4e00\u4e2a\u573a\u5730\u3002<\/p>\n\n\n\n<p>\u6839\u636e\u4ee5\u4e0a\u5b9e\u4f53\u753b\u51faER\u56fe\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"961\" height=\"582\" src=\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-14.png\" alt=\"\" class=\"wp-image-400\" srcset=\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-14.png 961w, http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-14-300x182.png 300w, http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-14-768x465.png 768w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3\u3001\u5173\u7cfb\u6a21\u5f0f<\/h3>\n\n\n\n<p>\u5b66\u9662\uff08\u7f16\u53f7\uff0c\u5b66\u9662\u540d\uff0c\u5efa\u9662\u5e74\u4efd\uff09\u4e3b\u952e\uff1a\u7f16\u53f7<\/p>\n\n\n\n<p>\u8fd0\u52a8\u5458\uff08\u7f16\u53f7\uff0c\u59d3\u540d\uff0c\u6027\u522b\uff0c\u5e74\u9f84\uff0c\u5b66\u9662\u7f16\u53f7\uff09 \u4e3b\u952e\uff1a\u7f16\u53f7\uff0c\u5916\u952e\uff1a\u5b66\u9662\u7f16\u53f7<\/p>\n\n\n\n<p>\u573a\u5730\uff08\u7f16\u53f7\uff0c\u5927\u5c0f\uff0c\u4eba\u6570\uff09\u4e3b\u952e\uff1a\u7f16\u53f7<\/p>\n\n\n\n<p>\u88c1\u5224\uff08\u7f16\u53f7\uff0c\u59d3\u540d\uff0c\u6027\u522b\uff0c\u5e74\u9f84\uff09 \u4e3b\u952e\uff1a\u7f16\u53f7<\/p>\n\n\n\n<p>\u9879\u76ee\uff08\u7f16\u53f7\uff0c\u540d\u79f0\uff0c\u7c7b\u578b\uff09\u4e3b\u952e\uff1a\u7f16\u53f7<\/p>\n\n\n\n<p>\u6bd4\u8d5b\uff08\u7f16\u53f7\uff0c\u540d\u79f0\uff0c\u6bd4\u8d5b\u65f6\u95f4\uff0c\u573a\u5730\u7f16\u53f7\uff09 \u4e3b\u952e\uff1a\u7f16\u53f7\uff0c\u5916\u952e\uff1a\u573a\u5730\u7f16\u53f7<\/p>\n\n\n\n<p>\u53c2\u8d5b\uff08\u8fd0\u52a8\u5458\u7f16\u53f7\uff0c\u6bd4\u8d5b\u7f16\u53f7\uff0c\u5f97\u5206\uff09 \u4e3b\u952e\uff1a\uff08\u8fdc\u52a8\u5458\u7f16\u53f7\u3001\u6bd4\u8d5b\u7f16\u53f7\uff09\u5916\u952e\uff1a\u8fd0\u52a8\u5458\u7f16\u53f7\u3001\u6bd4\u8d5b\u7f16\u53f7<\/p>\n\n\n\n<p>\u88c1\u51b3\uff08\u88c1\u5224\u7f16\u53f7\uff0c\u6bd4\u8d5b\u7f16\u53f7\uff09 \u4e3b\u952e\uff1a\uff08\u88c1\u5224\u7f16\u53f7\u3001\u6bd4\u8d5b\u7f16\u53f7\uff09 \u5916\u952e\uff1a\u88c1\u5224\u7f16\u53f7\u3001\u6bd4\u8d5b\u7f16\u53f7<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4\u3001\u521b\u5efa\u8868\u3001\u6dfb\u52a0\u6570\u636e<\/h3>\n\n\n\n<p>\u4ee5\u4e0bsql\u4ee3\u7801\u91c7\u7528mysql 5.6\u7248\u672c\u7f16\u5199\u3002<\/p>\n\n\n\n<p>-- \u521b\u5efa\u6570\u636e\u5e93<\/p>\n\n\n\n<p>create database sports<br>charset utf8;<\/p>\n\n\n\n<p>-- \u521b\u5efa\u5b66\u9662\u8868<\/p>\n\n\n\n<p>use sports;<br>create table college<br>(cid int primary key,<br>cname varchar(40) not null,<br>byear char(4));<\/p>\n\n\n\n<p>-- \u6dfb\u52a0\u5b66\u9662\u6570\u636e<\/p>\n\n\n\n<p>INSERT INTO <code>college<\/code> VALUES (1001,'\u6570\u7edf\u5b66\u9662','1967'),<br>(1002,'\u4fe1\u606f\u5de5\u7a0b\u5b66\u9662','1957'),(1003,'\u6587\u5b66\u9662','1945'),<br>(1004,'\u5916\u56fd\u8bed\u5b66\u9662','1966'),(1005,'\u73af\u5883\u5b66\u9662','1966'),<br>(1006,'\u6c34\u571f\u6c34\u5229\u5b66\u9662','1968'),(1007,'\u7269\u7406\u5b66\u9662','1967'),<br>(1008,'\u5316\u5b66\u9662','1977'),(1009,'\u519c\u5b66\u9662','1988'),(1010,'\u751f\u6001\u5b66\u9662','2002');<\/p>\n\n\n\n<p>-- \u521b\u5efa\u8fd0\u52a8\u5458\u8868<\/p>\n\n\n\n<p>create table athlete<br>(aid int primary key,<br>aname varchar(40) not null,<br>asex char(2) not null,<br>aage int,<br>cid int references college(cid));<\/p>\n\n\n\n<p>-- \u6dfb\u52a0\u8fd0\u52a8\u5458\u6570\u636e<\/p>\n\n\n\n<p>INSERT INTO <code>athlete<\/code> VALUES (1,'\u4f73\u4f73','\u5973',19,1004),(2,'\u9648\u5b50\u6021','\u5973',19,1004),<br>(3,'\u627f\u7fbd','\u7537',20,1006),(4,'\u7267\u4e00','\u7537',20,1007),(5,'\u4e00\u640f','\u7537',18,1008),<br>(6,'\u4e50\u8a00','\u5973',19,1010),(7,'\u601d\u6052','\u7537',10,1005),(8,'\u5c0f\u7ea2','\u5973',19,1007),<br>(9,'\u82b1\u82b1','\u5973',19,1008),(10,'\u535a\u57ce','\u7537',19,1004),(11,'\u5ed6\u5b50\u8f69','\u7537',20,1006),(12,'\u6587\u6587','\u5973',20,1002);<\/p>\n\n\n\n<p>\u3002\u3002\u3002\u3002\u3002\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5\u3001\u67e5\u8be2<\/h3>\n\n\n\n<p>-- \u67e5\u8be2\u8be6\u7ec6\u7684\u6bd4\u8d5b\u65e5\u7a0b<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"703\" height=\"334\" src=\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-15.png\" alt=\"\" class=\"wp-image-404\" srcset=\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-15.png 703w, http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-15-300x143.png 300w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/figure>\n\n\n\n<p>-- \u67e5\u8be2\u5404\u9879\u76ee\u6bd4\u8d5b\u7684\u7ed3\u679c<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"709\" height=\"690\" src=\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-16.png\" alt=\"\" class=\"wp-image-405\" srcset=\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-16.png 709w, http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/image-16-300x292.png 300w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><\/figure>\n\n\n\n<p>\u5b8c\u6574\u8d44\u6599\u4e0b\u8f7d\uff1a\u94fe\u63a5: <a href=\"https:\/\/pan.baidu.com\/s\/1H154njawoHjA_xpABBEqKw\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/pan.baidu.com\/s\/1H154njawoHjA_xpABBEqKw<\/a> <\/p>\n\n\n\n<p>\u63d0\u53d6\u7801: <p><div class=\"erphp-wppay\">\r\n\t\t\t\t\u60a8\u9700\u8981\u5148\u652f\u4ed8 <b>4.8\u5143<\/b> \u624d\u80fd\u67e5\u770b\u6b64\u5904\u5185\u5bb9\uff01<a href=\"javascript:;\" class=\"erphp-wppay-loader\" data-post=\"393\">\u7acb\u5373\u652f\u4ed8<\/a>\r\n\t\t\t<\/div><\/p><\/p>\n\n\n\n<p>\u6709\u4efb\u4f55\u95ee\u9898\u53ef\u4ee5<a href=\"http:\/\/www.keshebang.com\/?page_id=86\">\u8054\u7cfb\u6211\u4eec<\/a>\u3002<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u91c7\u7528mysql 5.6\u8fdb\u884c\u8fd0\u52a8\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff0c\u5305\u62ec\u9700\u6c42\u5206\u6790\u3001ER\u56fe\u8bbe\u8ba1\u3001\u5173\u7cfb\u6a21\u5f0f\u8bbe\u8ba1\u53ca\u521b\u5efa\u6570\u636e\u5e93\u3001\u8868\u3001\u6dfb\u52a0\u6570\u636e\u3001\u67e5\u8be2\u7684sql\u4ee3\u7801\u3002<\/p>\n","protected":false},"author":1,"featured_media":409,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[6],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u8fd0\u52a8\u4f1a\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff08ER\u56fe+sql\u4ee3\u7801\uff09 - \u8bfe\u8bbe\u5e2e<\/title>\n<meta name=\"description\" content=\"\u91c7\u7528mysql 5.6\u8fdb\u884c\u8fd0\u52a8\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff0c\u5305\u62ec\u9700\u6c42\u5206\u6790\u3001ER\u56fe\u8bbe\u8ba1\u3001\u5173\u7cfb\u6a21\u5f0f\u8bbe\u8ba1\u53ca\u521b\u5efa\u6570\u636e\u5e93\u3001\u8868\u3001\u6dfb\u52a0\u6570\u636e\u3001\u67e5\u8be2\u7684sql\u4ee3\u7801\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.keshebang.com\/?p=393\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u8fd0\u52a8\u4f1a\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff08ER\u56fe+sql\u4ee3\u7801\uff09 - \u8bfe\u8bbe\u5e2e\" \/>\n<meta property=\"og:description\" content=\"\u91c7\u7528mysql 5.6\u8fdb\u884c\u8fd0\u52a8\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff0c\u5305\u62ec\u9700\u6c42\u5206\u6790\u3001ER\u56fe\u8bbe\u8ba1\u3001\u5173\u7cfb\u6a21\u5f0f\u8bbe\u8ba1\u53ca\u521b\u5efa\u6570\u636e\u5e93\u3001\u8868\u3001\u6dfb\u52a0\u6570\u636e\u3001\u67e5\u8be2\u7684sql\u4ee3\u7801\u3002\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.keshebang.com\/?p=393\" \/>\n<meta property=\"og:site_name\" content=\"\u8bfe\u8bbe\u5e2e\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-28T14:53:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-13T02:01:26+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/\u8fd0\u52a8\u4f1a.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"junkui\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"junkui\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.keshebang.com\/?p=393\",\"url\":\"http:\/\/www.keshebang.com\/?p=393\",\"name\":\"\u8fd0\u52a8\u4f1a\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff08ER\u56fe+sql\u4ee3\u7801\uff09 - \u8bfe\u8bbe\u5e2e\",\"isPartOf\":{\"@id\":\"http:\/\/www.keshebang.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/www.keshebang.com\/?p=393#primaryimage\"},\"image\":{\"@id\":\"http:\/\/www.keshebang.com\/?p=393#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/\u8fd0\u52a8\u4f1a.png\",\"datePublished\":\"2025-02-28T14:53:56+00:00\",\"dateModified\":\"2025-07-13T02:01:26+00:00\",\"author\":{\"@id\":\"http:\/\/www.keshebang.com\/#\/schema\/person\/f253078d4cc39ff1ba6253edefd7458a\"},\"description\":\"\u91c7\u7528mysql 5.6\u8fdb\u884c\u8fd0\u52a8\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff0c\u5305\u62ec\u9700\u6c42\u5206\u6790\u3001ER\u56fe\u8bbe\u8ba1\u3001\u5173\u7cfb\u6a21\u5f0f\u8bbe\u8ba1\u53ca\u521b\u5efa\u6570\u636e\u5e93\u3001\u8868\u3001\u6dfb\u52a0\u6570\u636e\u3001\u67e5\u8be2\u7684sql\u4ee3\u7801\u3002\",\"breadcrumb\":{\"@id\":\"http:\/\/www.keshebang.com\/?p=393#breadcrumb\"},\"inLanguage\":\"zh-CN\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.keshebang.com\/?p=393\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-CN\",\"@id\":\"http:\/\/www.keshebang.com\/?p=393#primaryimage\",\"url\":\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/\u8fd0\u52a8\u4f1a.png\",\"contentUrl\":\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/\u8fd0\u52a8\u4f1a.png\",\"width\":200,\"height\":200},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.keshebang.com\/?p=393#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"http:\/\/www.keshebang.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u8fd0\u52a8\u4f1a\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff08ER\u56fe+sql\u4ee3\u7801\uff09\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.keshebang.com\/#website\",\"url\":\"http:\/\/www.keshebang.com\/\",\"name\":\"\u8bfe\u8bbe\u5e2e\",\"description\":\"\u63d0\u4f9b\u6570\u636e\u5e93\u76f8\u5173\u8bfe\u7a0b\u8bbe\u8ba1\u3001\u77e5\u8bc6\u5206\u4eab\u3001\u8f6f\u4ef6\u4e0b\u8f7d\u5b89\u88c5\u7b49\uff0c\u52a9\u4f60\u4e00\u81c2\u4e4b\u529b\uff01\uff01\uff01\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.keshebang.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-CN\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.keshebang.com\/#\/schema\/person\/f253078d4cc39ff1ba6253edefd7458a\",\"name\":\"junkui\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-CN\",\"@id\":\"http:\/\/www.keshebang.com\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/9128e1697db80f8c42fe689c44a6524e?s=96&d=identicon&r=g\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/9128e1697db80f8c42fe689c44a6524e?s=96&d=identicon&r=g\",\"caption\":\"junkui\"},\"sameAs\":[\"http:\/\/www.keshebang.com\"],\"url\":\"http:\/\/www.keshebang.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u8fd0\u52a8\u4f1a\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff08ER\u56fe+sql\u4ee3\u7801\uff09 - \u8bfe\u8bbe\u5e2e","description":"\u91c7\u7528mysql 5.6\u8fdb\u884c\u8fd0\u52a8\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff0c\u5305\u62ec\u9700\u6c42\u5206\u6790\u3001ER\u56fe\u8bbe\u8ba1\u3001\u5173\u7cfb\u6a21\u5f0f\u8bbe\u8ba1\u53ca\u521b\u5efa\u6570\u636e\u5e93\u3001\u8868\u3001\u6dfb\u52a0\u6570\u636e\u3001\u67e5\u8be2\u7684sql\u4ee3\u7801\u3002","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":"http:\/\/www.keshebang.com\/?p=393","og_locale":"zh_CN","og_type":"article","og_title":"\u8fd0\u52a8\u4f1a\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff08ER\u56fe+sql\u4ee3\u7801\uff09 - \u8bfe\u8bbe\u5e2e","og_description":"\u91c7\u7528mysql 5.6\u8fdb\u884c\u8fd0\u52a8\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff0c\u5305\u62ec\u9700\u6c42\u5206\u6790\u3001ER\u56fe\u8bbe\u8ba1\u3001\u5173\u7cfb\u6a21\u5f0f\u8bbe\u8ba1\u53ca\u521b\u5efa\u6570\u636e\u5e93\u3001\u8868\u3001\u6dfb\u52a0\u6570\u636e\u3001\u67e5\u8be2\u7684sql\u4ee3\u7801\u3002","og_url":"http:\/\/www.keshebang.com\/?p=393","og_site_name":"\u8bfe\u8bbe\u5e2e","article_published_time":"2025-02-28T14:53:56+00:00","article_modified_time":"2025-07-13T02:01:26+00:00","og_image":[{"width":200,"height":200,"url":"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/\u8fd0\u52a8\u4f1a.png","type":"image\/png"}],"author":"junkui","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"junkui","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.keshebang.com\/?p=393","url":"http:\/\/www.keshebang.com\/?p=393","name":"\u8fd0\u52a8\u4f1a\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff08ER\u56fe+sql\u4ee3\u7801\uff09 - \u8bfe\u8bbe\u5e2e","isPartOf":{"@id":"http:\/\/www.keshebang.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.keshebang.com\/?p=393#primaryimage"},"image":{"@id":"http:\/\/www.keshebang.com\/?p=393#primaryimage"},"thumbnailUrl":"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/\u8fd0\u52a8\u4f1a.png","datePublished":"2025-02-28T14:53:56+00:00","dateModified":"2025-07-13T02:01:26+00:00","author":{"@id":"http:\/\/www.keshebang.com\/#\/schema\/person\/f253078d4cc39ff1ba6253edefd7458a"},"description":"\u91c7\u7528mysql 5.6\u8fdb\u884c\u8fd0\u52a8\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff0c\u5305\u62ec\u9700\u6c42\u5206\u6790\u3001ER\u56fe\u8bbe\u8ba1\u3001\u5173\u7cfb\u6a21\u5f0f\u8bbe\u8ba1\u53ca\u521b\u5efa\u6570\u636e\u5e93\u3001\u8868\u3001\u6dfb\u52a0\u6570\u636e\u3001\u67e5\u8be2\u7684sql\u4ee3\u7801\u3002","breadcrumb":{"@id":"http:\/\/www.keshebang.com\/?p=393#breadcrumb"},"inLanguage":"zh-CN","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.keshebang.com\/?p=393"]}]},{"@type":"ImageObject","inLanguage":"zh-CN","@id":"http:\/\/www.keshebang.com\/?p=393#primaryimage","url":"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/\u8fd0\u52a8\u4f1a.png","contentUrl":"http:\/\/www.keshebang.com\/wp-content\/uploads\/2025\/02\/\u8fd0\u52a8\u4f1a.png","width":200,"height":200},{"@type":"BreadcrumbList","@id":"http:\/\/www.keshebang.com\/?p=393#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"http:\/\/www.keshebang.com\/"},{"@type":"ListItem","position":2,"name":"\u8fd0\u52a8\u4f1a\u7ba1\u7406\u7cfb\u7edf\u6570\u636e\u5e93\u8bbe\u8ba1\uff08ER\u56fe+sql\u4ee3\u7801\uff09"}]},{"@type":"WebSite","@id":"http:\/\/www.keshebang.com\/#website","url":"http:\/\/www.keshebang.com\/","name":"\u8bfe\u8bbe\u5e2e","description":"\u63d0\u4f9b\u6570\u636e\u5e93\u76f8\u5173\u8bfe\u7a0b\u8bbe\u8ba1\u3001\u77e5\u8bc6\u5206\u4eab\u3001\u8f6f\u4ef6\u4e0b\u8f7d\u5b89\u88c5\u7b49\uff0c\u52a9\u4f60\u4e00\u81c2\u4e4b\u529b\uff01\uff01\uff01","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.keshebang.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-CN"},{"@type":"Person","@id":"http:\/\/www.keshebang.com\/#\/schema\/person\/f253078d4cc39ff1ba6253edefd7458a","name":"junkui","image":{"@type":"ImageObject","inLanguage":"zh-CN","@id":"http:\/\/www.keshebang.com\/#\/schema\/person\/image\/","url":"http:\/\/0.gravatar.com\/avatar\/9128e1697db80f8c42fe689c44a6524e?s=96&d=identicon&r=g","contentUrl":"http:\/\/0.gravatar.com\/avatar\/9128e1697db80f8c42fe689c44a6524e?s=96&d=identicon&r=g","caption":"junkui"},"sameAs":["http:\/\/www.keshebang.com"],"url":"http:\/\/www.keshebang.com\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/posts\/393"}],"collection":[{"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=393"}],"version-history":[{"count":13,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/posts\/393\/revisions"}],"predecessor-version":[{"id":411,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/posts\/393\/revisions\/411"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/media\/409"}],"wp:attachment":[{"href":"http:\/\/www.keshebang.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=393"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}