零基础学SQL各个数据表用的SQL语句

/*创建数据库*/
CREATE DATABASE test_STInfo

************************************************************************
/*创建学生信息表*/
CREATE TABLE T_student (
stuID VARCHAR (15) PRIMARY KEY,
stuName VARCHAR (10)  NOT NULL,
age  INT  NOT NULL,
sex  VARCHAR (2) NOT NULL,
birth  DATETIME  NOT NULL
)

/*向学生信息表中插入一条学生信息*/
INSERT  INTO T_student
VALUES
('s102203','赵亮',23,'男', '19860516');

INSERT  INTO T_student
VALUES
('s115263','王海',23,'男', '19860802');

INSERT  INTO T_student
VALUES
('s206363','张明',22,'男', '19870423');

INSERT  INTO T_student
VALUES
('s112303','郑茹',21,'女', '19880125');

INSERT  INTO T_student
VALUES
('s253263','李凤',24,'女', '19850606');

INSERT  INTO T_student
VALUES
('s23256','李玉峰',24,'女', '19850816');

INSERT  INTO T_student
VALUES
('s231456','王玉梅',22,'女', '19870328');

INSERT  INTO T_student
VALUES
('s221256','王昌鹤',24,'男', '19850318');

************************************************************************
/*创建课程信息表*/
CREATE TABLE T_curriculum(
curID  VARCHAR (15) PRIMARY KEY,
curName VARCHAR (10)  NOT NULL,
credit  INT  NOT NULL,
learnTime  INT   NOT NULL,
teacherName  VARCHAR (10)  NOT NULL
)

/*向课程信息表中插入一条信息*/
INSERT  INTO T_curriculum
VALUES
('t105','计算机系统结构',4,80, '张昌');

INSERT  INTO T_curriculum
VALUES
('t232','数据库基础',5,90, '赵伟');

INSERT  INTO T_curriculum
VALUES
('t333','高等数学',4,80, '王新');

INSERT  INTO T_curriculum
VALUES
('t542','操作系统',3,60, '毛翠');

INSERT  INTO T_curriculum
VALUES
('t321','C语言',6,96, '于波');

*****************************************
/*创建成绩信息表*/
CREATE TABLE T_result(
stuID  VARCHAR (15) ,
curID  VARCHAR (15) ,
result  DOUBLE ,
PRIMARY KEY (stuID,curID)
)

/*向成绩信息表中插入一条信息*/

INSERT  INTO T_result
VALUES
('s102203','t105',85);

INSERT  INTO T_result
VALUES
('s102203','t232',75);

INSERT  INTO T_result
VALUES
('s102203','t333',60);

INSERT  INTO T_result
VALUES
('s102203','t321',90);

INSERT  INTO T_result
VALUES
('s206363','t105',80);

INSERT  INTO T_result
VALUES
('s206363','t333',55);

INSERT  INTO T_result
VALUES
('s206363','321',0);

INSERT  INTO T_result
VALUES
('s253263','t232',70);

INSERT  INTO T_result
VALUES
('s253263','t105',50);

INSERT  INTO T_result
VALUES
('s253263','t333',53);

INSERT  INTO T_result
VALUES
('s253263','t321',90);

INSERT  INTO T_result
VALUES
('s221256','t232',60);

********************************************
/*创建教师信息表*/

CREATE TABLE T_teacher (
teaID  VARCHAR (15) PRIMARY KEY,
teaName VARCHAR (10)  NOT NULL,
age  INT  NOT NULL,
sex  VARCHAR (2) NOT NULL,
deptID VARCHAR (15),
dept VARCHAR (20)  NOT NULL,
profession VA