SQL 基本建表语句

作为备忘吧.在机房里输入的.

/*CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
 Sname CHAR(20) UNIQUE,
 Ssex CHAR(2),
 Sage SMALLINT,
 Sdept CHAR(20)
);*/
/*CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
 Cname CHAR(40),
 Cpno CHAR(4),
 Credit SMALLINT,
 FOREIGN KEY (Cpno) REFERENCES Course(Cno)
);*/
/*ALTER TABLE Student ADD S_entrance CHAR;*/
/*ALTER TABLE Student ALTER COLUMN Sage INT;*/
/*ALTER TABLE Course ADD UNIQUE(Cname);*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage,Sdept)
VALUES ('200815128', '陈冬', '男', '20', 'IS');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage,Sdept)
VALUES ('200815129', '李芬', '女', '20', 'SR');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage,Sdept)
VALUES ('200815130', '洋洋', '男', '19', 'SR');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage, Sdept)
VALUES ('200815131', '吴建国', '男', '21', 'IS');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage,Sdept)
VALUES ('200815132', '陈浩南', '男', '20', 'SC');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage, Sdept)
VALUES ('200815133', '春冬', '女', '22', 'SC');*/

 

UPDATE Student
SET S_entrance = '8'
WHERE S_entrance IS NULL;

SELECT *
FROM Student

 

/*SELECT Sno, Sname
FROM Student
WHERE Sno IN
   (SELECT Sno
    FROM SC
    WHERE Cno IN
         (SELECT Cno
          FROM Course
          WHERE Cname = '信息系统'
         )
   );*/
/*select Sno, Sname, Sdept
from Student
where (Sno > 200215121);*/
/*select Sname, Sage
from Student
where Sage < ANY(SELECT Sage
                 FROM Student
                 where Sdept = 'CS')
AND Sdept <> 'CS';*/
/*SELECT Sname
FROM Student
where EXISTS
      (SELECT *
       FROM SC
       WHERE Sno = Student.Sno AND Cno = '1');*/