{"id":342,"date":"2024-05-15T14:51:37","date_gmt":"2024-05-15T14:51:37","guid":{"rendered":"http:\/\/www.keshebang.com\/?p=342"},"modified":"2024-05-15T14:51:38","modified_gmt":"2024-05-15T14:51:38","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e7%b3%bb%e7%bb%9f%e6%95%99%e6%9d%90spj%e6%95%b0%e6%8d%ae%e5%ba%93%e9%a2%98%e7%9b%ae%e5%8f%82%e8%80%83%e7%ad%94%e6%a1%88","status":"publish","type":"post","link":"http:\/\/www.keshebang.com\/?p=342","title":{"rendered":"\u6570\u636e\u5e93\u7cfb\u7edf\u6559\u6750SPJ\u6570\u636e\u5e93\u9898\u76ee\u53c2\u8003\u7b54\u6848"},"content":{"rendered":"\n

\u8bbe\u6709\u4e00\u4e2aSPJ\u6570\u636e\u5e93\uff0c\u5305\u62ecS\u3001P\u3001J\u3001SPJ\u56db\u4e2a\u5173\u7cfb\u6a21\u5f0f<\/p>\n\n\n\n

S(SNO\uff0cSNAME\uff0cSTATUS\uff0cCITY)\uff1a<\/p>\n\n\n\n

P(PNO\uff0cPNAME\uff0cCOLOR\uff0cWEIGHT)\uff1a<\/p>\n\n\n\n

J(JNO\uff0cJNAME\uff0cCITY)\uff1b<\/p>\n\n\n\n

SPJ(SNO\uff0cPNO\uff0cJNO\uff0cCITY)\uff1b<\/p>\n\n\n\n

\u4f9b\u5e94\u5546\u8868S\u7531\u4f9b\u5e94\u5546\u4ee3\u7801(SNO)\u3001\u4f9b\u5e94\u5546\u59d3\u540d(SNAME)\u3001\u4f9b\u5e94\u5546\u6240\u5728\u57ce\u5e02(CITY)\u7ec4\u6210\uff1b<\/p>\n\n\n\n

\u96f6\u4ef6\u8868P\u7531\u96f6\u4ef6\u4ee3\u7801(PNO)\u3001\u96f6\u4ef6\u540d(PNAME)\u3001\u989c\u8272(COLOR)\u3001\u91cd\u91cf\uff08WEIGHT\uff09\u7ec4\u6210\uff1a<\/p>\n\n\n\n

\u5de5\u7a0b\u9879\u76ee\u8868J\u7531\u5de5\u7a0b\u9879\u76ee\u4ee3\u7801(JNO)\u3001\u5de5\u7a0b\u9879\u76ee\u540d(JNAME)\u3001\u5de5\u7a0b\u9879J\u6240\u5728\u57ce\uff0c(CITY)\u7ec4\u6210\uff1a\u4f9b\u5e94\u60c5\u51b5\u8868SPJ\u4f9b\u5e94\u5357\u4ee3\u7801(SNO)\u3001\u96f6\u4ef6\u4ee3\u7801(PNO)\u3001\u5de5\u7a0b\u9876\u76ee\u4ee3\u7801\uff08JNO\uff09\uff0c\u4f9b\u5e94\u6570\u91cf(QTY)\u7ec4\u6210\uff0c\u8868\u793a\u67d0\u4f9b\u5e94\u5546\u4f9b\u5e94\u67d0\u79cd\u96f6\u4ef6\u7ed9\u67d0\u5de5\u7a0b\u9879\u76ee\u7684\u6570\u91cf\u4e3aQTY\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\u9898\u76ee\u53ca\u7b54\u6848\u5982\u4e0b\uff1a<\/mark><\/strong><\/p>\n\n\n\n

    \n
  1. \u7528SQL\u8bed\u53e5\u5efa\u7acb\u8fd9\u56db\u4e2a\u8868<\/strong>\u3002<\/li>\n<\/ol>\n\n\n\n

    create table S<\/p>\n\n\n\n

    (sno char(2) not null primary key,<\/p>\n\n\n\n

    sname varchar(10),<\/p>\n\n\n\n

    status int,<\/p>\n\n\n\n

    city varchar(10))<\/p>\n\n\n\n

    create table P<\/p>\n\n\n\n

    (pno char(2) not null primary key,<\/p>\n\n\n\n

    pname varchar(10),<\/p>\n\n\n\n

    color varchar(10),<\/p>\n\n\n\n

    weight int)<\/p>\n\n\n\n

    create table J<\/p>\n\n\n\n

    (jno char(2) not  null primary key,<\/p>\n\n\n\n

    jname varchar(10) ,<\/p>\n\n\n\n

    city varchar(10))<\/p>\n\n\n\n

    create table SPJ<\/p>\n\n\n\n

    (sno char(2) ,<\/p>\n\n\n\n

    pno char(2) ,<\/p>\n\n\n\n

    jno char(2) ,<\/p>\n\n\n\n

    qty int,<\/p>\n\n\n\n

    primary key(sno,pno,jno))<\/p>\n\n\n\n

    insert into s values('S1','\u7cbe\u76ca',20,'\u5929\u6d25');<\/p>\n\n\n\n

    insert into s values('S2','\u76db\u9521',10,'\u5317\u4eac');<\/p>\n\n\n\n

    insert into s values('S3','\u4e1c\u65b9\u7ea2',30,'\u5317\u4eac');<\/p>\n\n\n\n

    insert into s values('S4','\u4e30\u6cf0\u76db',20,'\u5929\u6d25');<\/p>\n\n\n\n

    insert into s values('S5','\u4e3a\u6c11',30,'\u4e0a\u6d77');<\/p>\n\n\n\n

    insert into p values('P1','\u87ba\u6bcd','\u7ea2',12);<\/p>\n\n\n\n

    insert into p values('P2','\u87ba\u6813','\u7eff',17);<\/p>\n\n\n\n

    insert into p values('P3','\u87ba\u4e1d\u5200','\u84dd',14);<\/p>\n\n\n\n

    insert into p values('P4','\u87ba\u4e1d\u5200','\u7ea2',14);<\/p>\n\n\n\n

    insert into p values('P5','\u51f8\u8f6e','\u84dd',40);<\/p>\n\n\n\n

    insert into p values('P6','\u9f7f\u8f6e','\u7ea2',30);<\/p>\n\n\n\n

    insert into j values('J1','\u4e09\u5efa','\u5317\u4eac');<\/p>\n\n\n\n

    insert into j values('J2','\u4e00\u6c7d','\u957f\u6625');<\/p>\n\n\n\n

    insert into j values('J3','\u5f39\u7c27\u5382','\u5929\u6d25');<\/p>\n\n\n\n

    insert into j values('J4','\u9020\u8239\u5382','\u5929\u6d25');<\/p>\n\n\n\n

    insert into j values('J5','\u673a\u8f66\u5382','\u5510\u5c71');<\/p>\n\n\n\n

    insert into j values('J6','\u65e0\u7ebf\u7535\u5382','\u5e38\u5dde');<\/p>\n\n\n\n

    insert into j values('J7','\u534a\u5bfc\u4f53\u5382','\u5357\u4eac');<\/p>\n\n\n\n

    insert into spj values('S1','P1','J1',200);<\/p>\n\n\n\n

    insert into spj values('S1','P1','J3',100);<\/p>\n\n\n\n

    insert into spj values('S1','P1','J4',700);<\/p>\n\n\n\n

    insert into spj values('S1','P2','J2',100);<\/p>\n\n\n\n

    insert into spj values('S2','P3','J1',400);<\/p>\n\n\n\n

    insert into spj values('S2','P3','J2',200);<\/strong><\/p>\n\n\n\n

    2.\u9488\u5bf9\u4ee5\u4e0a\u56db\u4e2a\u8868\u7528SQL\u8bed\u53e5\u5b8c\u6210\u4ee5\u4e0b\u64cd\u4f5c<\/strong><\/p>\n\n\n\n

    (1)\u627e\u51fa\u6240\u6709\u4f9b\u5e94\u5546\u7684\u59d3\u540d\u548c\u6240\u5728\u57ce\u5e02\u3002<\/p>\n\n\n\n

    select sname,city from s<\/strong><\/p>\n\n\n\n

    (2)\u627e\u51fa\u6240\u6709\u96f6\u4ef6\u7684\u540d\u79f0\u3001\u989c\u8272\u3001\u91cd\u91cf\u3002<\/p>\n\n\n\n

    select pname,color,weight from p<\/strong><\/p>\n\n\n\n

    (3)\u627e\u51fa\u4f7f\u7528\u4f9b\u5e94\u5546S1\u6240\u4f9b\u5e94\u96f6\u4ef6\u7684\u5de5\u7a0b\u53f7\u7801\u3002<\/p>\n\n\n\n

    select jno from spj<\/p>\n\n\n\n

    where sno='S1'<\/strong><\/p>\n\n\n\n

    (4)\u627e\u51fa\u5de5\u7a0b\u9879\u76eeJ2\u4f7f\u7528\u7684\u5404\u79cd\u96f6\u4ef6\u7684\u540d\u79f0\u53ca\u5176\u6570\u91cfG\u3001<\/p>\n\n\n\n

    select pname,qty<\/p>\n\n\n\n

    from p,spj<\/p>\n\n\n\n

    where p.pno=spj.pno and jno='J2'<\/strong><\/p>\n\n\n\n

    (5)\u627e\u51fa\u4e0a\u6d77\u5382\u5546\u4f9b\u5e94\u7684\u6240\u6709\u96f6\u4ef6\u53f7\u7801\u3002<\/p>\n\n\n\n

    select pno<\/p>\n\n\n\n

    from s,spj<\/p>\n\n\n\n

    where s.sno=spj.sno<\/p>\n\n\n\n

    and city='\u4e0a\u6d77'<\/strong><\/p>\n\n\n\n

    (6)\u627e\u51fa\u4f7f\u7528\u4e0a\u6d77\u4ea7\u7684\u96f6\u4ef6\u7684\u5de5\u7a0b\u540d\u79f0\u3002<\/p>\n\n\n\n

    select jname<\/p>\n\n\n\n

    from s,spj,j<\/p>\n\n\n\n

    where s.sno=spj.sno and j.jno=spj.jno<\/p>\n\n\n\n

    and s.city='\u4e0a\u6d77'<\/strong><\/p>\n\n\n\n

    (7)\u627e\u51fa\u6ca1\u6709\u4f7f\u7528\u5929\u6d25\u4ea7\u7684\u96f6\u4ef6\u7684\u5de5\u7a0b\u53f7\u7801\u3002<\/p>\n\n\n\n

    select jno<\/p>\n\n\n\n

    from s,spj<\/p>\n\n\n\n

    where s.sno=spj.sno<\/p>\n\n\n\n

    and s.city<>'\u5929\u6d25'<\/strong><\/p>\n\n\n\n

    (8)\u628a\u5168\u90e8\u7ea2\u8272\u96f6\u4ef6\u7684\u989c\u8272\u6539\u6210\u84dd\u8272\u3002<\/p>\n\n\n\n

    update p set color='\u84dd' where color='\u7ea2'<\/strong><\/p>\n\n\n\n

    (9)\u7531S5\u4f9b\u7ed9J4\u7684\u96f6\u4ef6S6\u6539\u4e3a\u7531S1\u4f9b\u5e94\uff0c\u8bf7\u505a\u5fc5\u8981\u7684\u4fee\u6539<\/p>\n\n\n\n

    update spj set sno='S1'<\/p>\n\n\n\n

    where sno='S5' and jno='J4' and pno='S6'<\/strong><\/p>\n\n\n\n

    (10)\u4ece\u4f9b\u5e94\u5546\u5173\u7cfb\u4e2d\u5220\u9664s2\u7684\u8bb0\u5f55\uff0c\u5e76\u4ece\u4f9b\u5e94\u60c5\u51b5\u5173\u7cfb\u4e2d\u5220\u9664\u76f8\u5e94\u7684\u8bb0\u5f55\u3002<\/p>\n\n\n\n

    delete from spj where sno='S2'<\/strong><\/p>\n\n\n\n

    delete from s where sno='S2'<\/strong><\/p>\n\n\n\n

    (11)\u8bf7\u5c06(S2\uff0cJ6\uff0cP4\uff0c200)\u63d2\u5165\u4f9b\u5e94\u60c5\u51b5\u5173\u7cfb\u3002<\/p>\n\n\n\n

    insert into spj values('S2','P4','J6',200)<\/p>\n\n\n\n

    (12)\u7edf\u8ba1\u5404\u4e2a\u4f9b\u5e94\u5546\u4f9b\u5e94\u7684\u96f6\u4ef6\u603b\u6570\u3002<\/p>\n\n\n\n

    select sno,SUM(qty) total_qty<\/p>\n\n\n\n

    from spj<\/p>\n\n\n\n

    group by sno<\/strong><\/p>\n\n\n\n

    (13)\u67e5\u8be2\u603b\u4f9b\u5e94\u91cf\u5728600\u4ee5\u4e0a\u7684\u4f9b\u5e94\u5546\u7684\u59d3\u540d\u3001\u4f9b\u5e94\u5546\u7f16\u53f7\u3001\u603b\u4f9b\u5e94\u6570\u91cf\u3002<\/p>\n\n\n\n

    select sname,s.sno,SUM(qty) total_qty<\/p>\n\n\n\n

    from spj,s<\/p>\n\n\n\n

    where s.sno=spj.sno<\/p>\n\n\n\n

    group by s.sno,sname<\/p>\n\n\n\n

    having SUM(qty)>600<\/strong><\/p>\n\n\n\n

    (14)\u6c42\u81f3\u5c11\u7528\u4e86\u4f9b\u5e94\u5546S1\u6240\u4f9b\u5e94\u7684\u5168\u90e8\u96f6\u4ef6\u7684\u5de5\u7a0b\u53f7JNO\uff1a<\/p>\n\n\n\n

    select jno from j as a where not exists(<\/p>\n\n\n\n

    select *from<\/p>\n\n\n\n

    (select b.pno from spj as b where b.sno='S1') as d<\/p>\n\n\n\n

    where d.pno not in(<\/p>\n\n\n\n

    select c.pno from spj as c where c.jno=a.jno))<\/strong><\/p>\n\n\n\n

    3\u3001\u8bf7\u4e3a\u4e09\u5efa\u5de5\u7a0b\u9879\u76ee\u5efa\u7acb\u4e00\u4e2a\u4f9b\u5e94\u60c5\u51b5\u7684\u89c6\u56fe\uff0c\u5305\u62ec\u4f9b\u5e94\u4e24\u4ee3\u7801(SNO)\u3001\u96f6\u4ef6\u4ee3\u7801(PNO)\u3001\u4f9b\u5e94\u6570\u91cf(QTY)\u3002<\/p>\n\n\n\n

    create view spj_view<\/p>\n\n\n\n

    as<\/p>\n\n\n\n

    select sno,pno,qty<\/p>\n\n\n\n

    from spj,j<\/p>\n\n\n\n

    where j.jno=spj.jno<\/p>\n\n\n\n

    and jname='\u4e09\u5efa'<\/p>\n\n\n\n

    \u9488\u5bf9\u8be5\u89c6\u56fe\u5b8c\u6210\u4e0b\u5217\u67e5\u8be2\uff1a<\/p>\n\n\n\n

    (1)\u627e\u51fa\u4e09\u5efa\u5de5\u7a0b\u9879\u76ee\u4f7f\u7528\u7684\u5404\u79cd\u96f6\u4ef6\u4ee3\u7801\u53ca\u5176\u6570\u91cf\u3002<\/p>\n\n\n\n

    select pno,qty from spj_view<\/strong><\/p>\n\n\n\n

    (2)\u627e\u51fa\u4f9b\u5e94\u5546S1\u7684\u4f9b\u5e94\u60c5\u51b5\u3002<\/p>\n\n\n\n

    select * from spj_view<\/p>\n\n\n\n

    where sno='S1'<\/strong><\/p>\n\n\n\n

    4\u3001\u9488\u4ee5\u4e0a\u8868\uff0c\u7528SQL\u8bed\u8a00\u5b8c\u6210\u4ee5\u4e0b\u5404\u9879\u64cd\u4f5c\uff1a<\/strong><\/p>\n\n\n\n

    (1)\u628a\u5bf9\u8868S\u7684INSERT\u6743\u9650\u6388\u4e88\u7528\u6237\u2018\u5f20\u52c7\u2019\uff0c\u5e76\u5141\u8bb8\u4ed6\u518d\u5c06\u6b64\u6743\u9650\u6388\u4e88\u5176\u4ed6\u7528\u6237\u3002<\/p>\n\n\n\n

    grant insert on s to \u5f20\u52c7 with grant option<\/strong><\/p>\n\n\n\n

    (2)\u628a\u67e5\u8be2SPJ\u8868\u548c\u4fee\u6539QTY\u5c5e\u6027\u7684\u6743\u9650\u6388\u4e88\u7528\u6237\u2018\u674e\u5929\u660e\u2019\u3002<\/p>\n\n\n\n

    grant select on spj to \u674e\u5929\u660e<\/p>\n\n\n\n

    grant update(qty) on spj to \u674e\u5929\u660e<\/p>\n\n\n\n

    WORD\u7248\u4e0b\u8f7d\uff08\u5305\u542b\u5168\u5957\u4ee3\u7801\u53ca\u8fd0\u884c\u622a\u56fe\uff09<\/mark><\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    \u94fe\u63a5: https:\/\/pan.baidu.com\/s\/1mvevbKAUj8ZCEB2h1NrPIg<\/a> <\/p>\n\n\n\n

    \u63d0\u53d6\u7801:

    \r\n\t\t\t\t\u60a8\u9700\u8981\u5148\u652f\u4ed8 9.9\u5143<\/b> \u624d\u80fd\u67e5\u770b\u6b64\u5904\u5185\u5bb9\uff01\u7acb\u5373\u652f\u4ed8<\/a>\r\n\t\t\t<\/div><\/p> <\/p>\n","protected":false},"excerpt":{"rendered":"

    \u8bbe\u6709\u4e00\u4e2aSPJ\u6570\u636e\u5e93\uff0c\u5305\u62ecS\u3001P\u3001J\u3001SPJ\u56db\u4e2a\u5173\u7cfb\u6a21\u5f0f
    \nS(SNO\uff0cSNAME\uff0cSTATUS\uff0cCITY)\uff1a
    \nP(PNO\uff0cPNAME\uff0cCOLOR\uff0cWEIGHT)\uff1a
    \nJ(JNO\uff0cJNAME\uff0cCITY)\uff1b
    \nSPJ(SNO\uff0cPNO\uff0cJNO\uff0cCITY)\uff1b<\/p>\n","protected":false},"author":1,"featured_media":349,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"yoast_head":"\n\u6570\u636e\u5e93\u7cfb\u7edf\u6559\u6750SPJ\u6570\u636e\u5e93\u9898\u76ee\u53c2\u8003\u7b54\u6848 - \u8bfe\u8bbe\u5e2e<\/title>\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=342\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u6570\u636e\u5e93\u7cfb\u7edf\u6559\u6750SPJ\u6570\u636e\u5e93\u9898\u76ee\u53c2\u8003\u7b54\u6848 - \u8bfe\u8bbe\u5e2e\" \/>\n<meta property=\"og:description\" content=\"\u8bbe\u6709\u4e00\u4e2aSPJ\u6570\u636e\u5e93\uff0c\u5305\u62ecS\u3001P\u3001J\u3001SPJ\u56db\u4e2a\u5173\u7cfb\u6a21\u5f0f S(SNO\uff0cSNAME\uff0cSTATUS\uff0cCITY)\uff1a P(PNO\uff0cPNAME\uff0cCOLOR\uff0cWEIGHT)\uff1a J(JNO\uff0cJNAME\uff0cCITY)\uff1b SPJ(SNO\uff0cPNO\uff0cJNO\uff0cCITY)\uff1b\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.keshebang.com\/?p=342\" \/>\n<meta property=\"og:site_name\" content=\"\u8bfe\u8bbe\u5e2e\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-15T14:51:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-15T14:51:38+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2024\/05\/sql.png\" \/>\n\t<meta property=\"og:image:width\" content=\"202\" \/>\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=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.keshebang.com\/?p=342\",\"url\":\"http:\/\/www.keshebang.com\/?p=342\",\"name\":\"\u6570\u636e\u5e93\u7cfb\u7edf\u6559\u6750SPJ\u6570\u636e\u5e93\u9898\u76ee\u53c2\u8003\u7b54\u6848 - \u8bfe\u8bbe\u5e2e\",\"isPartOf\":{\"@id\":\"http:\/\/www.keshebang.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/www.keshebang.com\/?p=342#primaryimage\"},\"image\":{\"@id\":\"http:\/\/www.keshebang.com\/?p=342#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2024\/05\/sql.png\",\"datePublished\":\"2024-05-15T14:51:37+00:00\",\"dateModified\":\"2024-05-15T14:51:38+00:00\",\"author\":{\"@id\":\"http:\/\/www.keshebang.com\/#\/schema\/person\/f253078d4cc39ff1ba6253edefd7458a\"},\"breadcrumb\":{\"@id\":\"http:\/\/www.keshebang.com\/?p=342#breadcrumb\"},\"inLanguage\":\"zh-CN\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.keshebang.com\/?p=342\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-CN\",\"@id\":\"http:\/\/www.keshebang.com\/?p=342#primaryimage\",\"url\":\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2024\/05\/sql.png\",\"contentUrl\":\"http:\/\/www.keshebang.com\/wp-content\/uploads\/2024\/05\/sql.png\",\"width\":202,\"height\":200},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.keshebang.com\/?p=342#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"http:\/\/www.keshebang.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u6570\u636e\u5e93\u7cfb\u7edf\u6559\u6750SPJ\u6570\u636e\u5e93\u9898\u76ee\u53c2\u8003\u7b54\u6848\"}]},{\"@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":"\u6570\u636e\u5e93\u7cfb\u7edf\u6559\u6750SPJ\u6570\u636e\u5e93\u9898\u76ee\u53c2\u8003\u7b54\u6848 - \u8bfe\u8bbe\u5e2e","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=342","og_locale":"zh_CN","og_type":"article","og_title":"\u6570\u636e\u5e93\u7cfb\u7edf\u6559\u6750SPJ\u6570\u636e\u5e93\u9898\u76ee\u53c2\u8003\u7b54\u6848 - \u8bfe\u8bbe\u5e2e","og_description":"\u8bbe\u6709\u4e00\u4e2aSPJ\u6570\u636e\u5e93\uff0c\u5305\u62ecS\u3001P\u3001J\u3001SPJ\u56db\u4e2a\u5173\u7cfb\u6a21\u5f0f S(SNO\uff0cSNAME\uff0cSTATUS\uff0cCITY)\uff1a P(PNO\uff0cPNAME\uff0cCOLOR\uff0cWEIGHT)\uff1a J(JNO\uff0cJNAME\uff0cCITY)\uff1b SPJ(SNO\uff0cPNO\uff0cJNO\uff0cCITY)\uff1b","og_url":"http:\/\/www.keshebang.com\/?p=342","og_site_name":"\u8bfe\u8bbe\u5e2e","article_published_time":"2024-05-15T14:51:37+00:00","article_modified_time":"2024-05-15T14:51:38+00:00","og_image":[{"width":202,"height":200,"url":"http:\/\/www.keshebang.com\/wp-content\/uploads\/2024\/05\/sql.png","type":"image\/png"}],"author":"junkui","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"junkui","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.keshebang.com\/?p=342","url":"http:\/\/www.keshebang.com\/?p=342","name":"\u6570\u636e\u5e93\u7cfb\u7edf\u6559\u6750SPJ\u6570\u636e\u5e93\u9898\u76ee\u53c2\u8003\u7b54\u6848 - \u8bfe\u8bbe\u5e2e","isPartOf":{"@id":"http:\/\/www.keshebang.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.keshebang.com\/?p=342#primaryimage"},"image":{"@id":"http:\/\/www.keshebang.com\/?p=342#primaryimage"},"thumbnailUrl":"http:\/\/www.keshebang.com\/wp-content\/uploads\/2024\/05\/sql.png","datePublished":"2024-05-15T14:51:37+00:00","dateModified":"2024-05-15T14:51:38+00:00","author":{"@id":"http:\/\/www.keshebang.com\/#\/schema\/person\/f253078d4cc39ff1ba6253edefd7458a"},"breadcrumb":{"@id":"http:\/\/www.keshebang.com\/?p=342#breadcrumb"},"inLanguage":"zh-CN","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.keshebang.com\/?p=342"]}]},{"@type":"ImageObject","inLanguage":"zh-CN","@id":"http:\/\/www.keshebang.com\/?p=342#primaryimage","url":"http:\/\/www.keshebang.com\/wp-content\/uploads\/2024\/05\/sql.png","contentUrl":"http:\/\/www.keshebang.com\/wp-content\/uploads\/2024\/05\/sql.png","width":202,"height":200},{"@type":"BreadcrumbList","@id":"http:\/\/www.keshebang.com\/?p=342#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"http:\/\/www.keshebang.com\/"},{"@type":"ListItem","position":2,"name":"\u6570\u636e\u5e93\u7cfb\u7edf\u6559\u6750SPJ\u6570\u636e\u5e93\u9898\u76ee\u53c2\u8003\u7b54\u6848"}]},{"@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\/342"}],"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=342"}],"version-history":[{"count":3,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions"}],"predecessor-version":[{"id":350,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions\/350"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=\/wp\/v2\/media\/349"}],"wp:attachment":[{"href":"http:\/\/www.keshebang.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=342"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.keshebang.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}