{"id":576,"date":"2022-09-28T18:07:57","date_gmt":"2022-09-28T10:07:57","guid":{"rendered":"https:\/\/qaqaq.top\/?p=576"},"modified":"2022-11-27T12:43:53","modified_gmt":"2022-11-27T04:43:53","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%89%e5%bc%a0%e8%a1%a8sql%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=576","title":{"rendered":"\u6570\u636e\u5e93\u4e09\u5f20\u8868SQL\u8bed\u53e5"},"content":{"rendered":"\n<p>\u521b\u5efaStudent\u8868<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Student (\n\tSno CHAR(7) PRIMARY KEY,\n\tSname CHAR(10) NOT NULL,\n\tSsex CHAR(2),\n\tSage TINYINT,\n\tSdept CHAR(20)\n)<\/code><\/pre>\n\n\n\n<p>\u521b\u5efaCourse\u8868<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Course(\n\tCno CHAR(6) NOT NULL PRIMARY KEY,\n\tCname CHAR(20) NOT NULL,\n\tCredit TINYINT,\n\tSemester TINYINT,\n)<\/code><\/pre>\n\n\n\n<p>\u521b\u5efaSC\u8868<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE SC(\n\tSno CHAR(7) NOT NULL,\n\tCno CHAR(6) NOT NULL,\n\tGrade SMALLINT,\n\tPRIMARY KEY(Sno,Cno),\n\tFOREIGN\tKEY(Sno) REFERENCES Student(Sno),\n\tFOREIGN KEY(Cno) REFERENCES Course(Cno)\n\n)<\/code><\/pre>\n\n\n\n<p>\u521b\u5efaStudent\u8868\u6570\u636e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO Student\nVALUES('1512101','\u674e\u52c7','\u7537',19,'\u8ba1\u7b97\u673a\u7cfb'),('1512102','\u5218\u6668','\u7537',20,'\u8ba1\u7b97\u673a\u7cfb'),\n('1512103','\u738b\u654f','\u5973',18,'\u8ba1\u7b97\u673a\u7cfb'),('1512104','\u674e\u5c0f\u73b2','\u5973',19,'\u8ba1\u7b97\u673a\u7cfb'),('1521101','\u5f20\u7acb','\u7537',22,'\u4fe1\u606f\u7cfb'),\n('1521102','\u5434\u5bbe','\u5973',21,'\u4fe1\u606f\u7cfb'),('1521103','\u5f20\u6d77','\u7537',20,'\u4fe1\u606f\u7cfb'),('1531101','\u94b1\u5c0f\u5e73','\u5973',18,'\u6570\u5b66\u7cfb'),\n('1531102','\u738b\u5927\u529b','\u7537',19,'\u6570\u5b66\u7cfb')<\/code><\/pre>\n\n\n\n<p>\u521b\u5efaCourse\u8868\u6570\u636e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO Course\nVALUES('c001','\u8ba1\u7b97\u673a\u6587\u5316\u5b66',3,1),('c002','\u9ad8\u7b49\u6570\u5b66',6,1),('c003','\u9ad8\u7b49\u6570\u5b66',3,2),\n('c004','\u5927\u5b66\u82f1\u8bed',6,2),('c005','Java',2,3),('c006','\u7a0b\u5e8f\u8bbe\u8ba1',3,3),\n('c007','\u6570\u636e\u7ed3\u6784',5,4),('c008','\u64cd\u4f5c\u7cfb\u7edf',4,4),('c009','\u6570\u636e\u5e93\u57fa\u7840',4,5),\n('c010','\u8ba1\u7b97\u673a\u7f51\u7edc',5,6)\n<\/code><\/pre>\n\n\n\n<p>\u521b\u5efaSC\u8868\u6570\u636e \u6709\u95ee\u9898<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO SC\nVALUES('1512101','c001',90),('1512101','c002',86),('1512101','c003',92),('1512101','c005',88),('1512101','c006',NULL),\n('1512102','c001',76),('1512102','c002',78),('1512102','c005',66),\n('1512104','c002',66),('1512104','c005',78),('1512104','c008',66),\n('1521102','c001',82),('1521102','c005',75),('1521102','c007',92),('1521102','c009',50),\n('1521103','c002',68),('1521103','c006',NULL),('1521103','c007',NULL),('1521103','c008',78),\n('1531101','c001',80),('1531101','c005',50),('1531101','c007',45),\n('1531102','c001',80),('1531102','c002',75),('1531102','c005',85),('1531102','c009',88)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u521b\u5efaStudent\u8868 \u521b\u5efaCourse\u8868 \u521b\u5efaSC\u8868 \u521b\u5efaStudent\u8868\u6570\u636e \u521b\u5efaCourse\u8868\u6570\u636e \u521b\u5efaS [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[57],"class_list":["post-576","post","type-post","status-publish","format-standard","hentry","category-25","tag-57"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/576"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=576"}],"version-history":[{"count":4,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/576\/revisions"}],"predecessor-version":[{"id":843,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/576\/revisions\/843"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}