{"id":1267,"date":"2025-03-10T15:42:52","date_gmt":"2025-03-10T07:42:52","guid":{"rendered":"http:\/\/113.45.254.23\/?p=1267"},"modified":"2025-03-10T15:42:52","modified_gmt":"2025-03-10T07:42:52","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e6%9f%a5%e8%af%a2-%e7%9b%b8%e5%85%b3%e5%ae%9e%e9%aa%8c","status":"publish","type":"post","link":"http:\/\/113.45.254.23\/?p=1267","title":{"rendered":"\u6570\u636e\u5e93\u67e5\u8be2 \u76f8\u5173\u5b9e\u9a8c"},"content":{"rendered":"\n

\u521b\u5efa\u73ed\u7ea7\u6570\u636e\u5e93<\/p>\n\n\n\n

MariaDB [(none)]> create database banji;\t\t\t\u521b\u5efa\u73ed\u7ea7\u6570\u636e\u5e93\nQuery OK, 1 row affected (0.000 sec)\n\nMariaDB [(none)]> use banji;\t\t\t\t\t\u4f7f\u7528\u73ed\u7ea7\u6570\u636e\u5e93\nDatabase changed\nMariaDB [banji]> CREATE TABLE student (\t\t\u521b\u5efa\u5b66\u751f\u8868\n    -> id INT(10) NOT NULL UNIQUE PRIMARY KEY ,\t \t\tid\u6574\u6570\u7c7b\u578b\u957f\u5ea6\u662f10\uff1b\u4e0d\u5141\u8bb8\u4e3a\u7a7a\uff1b\u8bbe\u7f6e\u7ec4\u4ef6\u4e3a\u552f\u4e00\u503c\n    -> name VARCHAR(20) NOT NULL ,\t\t\t\u540d\u5b57\uff1a\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u4e0d\u5141\u8bb8\u4e3a\u7a7a\n    -> sex VARCHAR(4) ,\t\t\t\t\t\t\u6027\u522b\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u957f\u5ea610\n    -> birth YEAR,\t\t\t\t\t\t\t\t\u51fa\u751f\u65e5\u671f\uff1a\u5e74\u4efd\n    -> department VARCHAR(20) ,\t\t\t\t\u9662\u7cfb\uff1a\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u957f\u5ea620\n    -> address VARCHAR(50)\t\t\t\t\t\u5730\u5740\uff1a\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u957f\u5ea650\n    -> );\nQuery OK, 0 rows affected (0.010 sec)\n\n\nMariaDB [banji]> CREATE TABLE score (\t\t\t\u521b\u5efa\u5206\u6570\u8868\n    -> id INT(10) NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT ,\tid\u4e3a\u6574\u6570\u7c7b\u578b\uff0c\u957f\u5ea610\uff0c\u4e0d\u5141\u8bb8\u4e3a\u7a7a\uff0c\u8bbe\u7f6e\u7ec4\u4ef6\u552f\u4e00\u503c\u5e76\u81ea\u52a8\u589e\u957f\uff0c\n    -> stu_id INT(10) NOT NULL ,\t\t\t\t\tstu_id\u6574\u6570\u7c7b\u578b\uff0c\u957f\u5ea6\u662f10\uff0c\u4e0d\u5141\u8bb8\u4e3a\u7a7a\n    -> c_name VARCHAR(20) ,\t\t\t\t\t\n    -> grade INT(10)\n    -> );\nQuery OK, 0 rows affected (0.002 sec)<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u8fdb\u5165\u73ed\u7ea7\u6570\u636e\u5e93<\/p>\n\n\n\n
\u521b\u5efa\u5b66\u751f\u6570\u636e\u8868<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u521b\u5efa\u6210\u7ee9\u6570\u636e\u8868<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
3.\u67e5\u8be2student\u8868\u7684\u6240\u6709\u8bb0\u5f55<\/p>\n\n\n\n
4.\u67e5\u8be2student\u8868\u7684\u7b2c2\u6761\u52304\u6761\u8bb0\u5f55<\/p>\n\n\n\n
5.\u4ecestudent\u8868\u67e5\u8be2\u6240\u6709\u5b66\u751f\u7684\u5b66\u53f7\uff08id\uff09\u3001\u59d3\u540d\uff08name\uff09\u548c\u9662\u7cfb\uff08department\uff09\u7684\u4fe1\u606f<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
7.\u4ecestudent\u8868\u4e2d\u67e5\u8be2\u5e74\u9f8418~22\u5c81\u7684\u5b66\u751f\u4fe1\u606f<\/p>\n\n\n\n
8.\u4ecestudent\u8868\u4e2d\u67e5\u8be2\u6bcf\u4e2a\u9662\u7cfb\u6709\u591a\u5c11\u4eba<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
9.\u4ecescore\u8868\u4e2d\u67e5\u8be2\u6bcf\u4e2a\u79d1\u76ee\u7684\u6700\u9ad8\u5206<\/p>\n\n\n\n
SELECT student.name ,score.grade FROM student ,score\nWHERE student.id IN( SELECT stu_id FROM score WHERE grade IN(SELECT MAX(grade) FROM score\nGROUP BY c_name) ) AND score.stu_id=student.id GROUP BY student.name;<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
10.\u67e5\u8be2\u90ed\u9756\u7684\u8003\u8bd5\u79d1\u76ee\uff08c_name\uff09\u548c\u8003\u8bd5\u6210\u7ee9\uff08grade\uff09<\/p>\n\n\n\n
11.\u7528\u8fde\u63a5\u7684\u65b9\u5f0f\u67e5\u8be2\u6240\u6709\u5b66\u751f\u7684\u4fe1\u606f\u548c\u8003\u8bd5\u4fe1\u606f<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
12.\u8ba1\u7b97\u6bcf\u4e2a\u5b66\u751f\u7684\u603b\u6210\u7ee9<\/p>\n\n\n\n
13.\u8ba1\u7b97\u6bcf\u4e2a\u8003\u8bd5\u79d1\u76ee\u7684\u5e73\u5747\u6210\u7ee9<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
14.\u67e5\u8be2\u8ba1\u7b97\u673a\u6210\u7ee9\u4f4e\u4e8e95\u7684\u5b66\u751f\u4fe1\u606f<\/p>\n\n\n\n
15.\u67e5\u8be2\u540c\u65f6\u53c2\u52a0\u8ba1\u7b97\u673a\u548c\u82f1\u8bed\u8003\u8bd5\u7684\u5b66\u751f\u7684\u4fe1\u606f<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
15.\u67e5\u8be2\u540c\u65f6\u53c2\u52a0\u8ba1\u7b97\u673a\u548c\u82f1\u8bed\u8003\u8bd5\u7684\u5b66\u751f\u7684\u4fe1\u606f<\/p>\n\n\n\n
16.\u5c06\u8ba1\u7b97\u673a\u8003\u8bd5\u6210\u7ee9\u6309\u4ece\u9ad8\u5230\u4f4e\u8fdb\u884c\u6392\u5e8f<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
17.\u4ecestudent\u8868\u548cscore\u8868\u4e2d\u67e5\u8be2\u51fa\u5b66\u751f\u7684\u5b66\u53f7\uff0c\u7136\u540e\u5408\u5e76\u67e5\u8be2\u7ed3\u679c<\/p>\n\n\n\n
18.\u67e5\u8be2\u59d3\u90ed\u6216\u8005\u59d3\u9ec4\u7684\u540c\u5b66\u7684\u59d3\u540d\u3001\u9662\u7cfb\u548c\u8003\u8bd5\u79d1\u76ee\u53ca\u6210\u7ee9<\/p>\n\n\n\n
19.\u67e5\u8be2\u90fd\u662f\u6e56\u5357\u7684\u5b66\u751f\u7684\u59d3\u540d\u3001\u5e74\u9f84\u3001\u9662\u7cfb\u548c\u8003\u8bd5\u79d1\u76ee\u53ca\u6210\u7ee9<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u6570\u636e\u5e93\u5173\u673a\u505a\u5feb\u7167\uff1b<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u521b\u5efa\u73ed\u7ea7\u6570\u636e\u5e93 \u8fdb\u5165\u73ed\u7ea7\u6570\u636e\u5e93 \u521b\u5efa\u5b66\u751f\u6570\u636e\u8868 \u521b\u5efa\u6210\u7ee9\u6570\u636e\u8868 3.\u67e5\u8be2student\u8868\u7684\u6240\u6709\u8bb0\u5f55 4.\u67e5\u8be2s […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[59,60],"class_list":["post-1267","post","type-post","status-publish","format-standard","hentry","category-linux","tag-where-","tag-60"],"_links":{"self":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/1267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1267"}],"version-history":[{"count":2,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/1267\/revisions"}],"predecessor-version":[{"id":1290,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/1267\/revisions\/1290"}],"wp:attachment":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1267"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}