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

)

/*向教师信息中插入一条信息*/
INSERT  INTO T_teacher
VALUES
('t103265','张昌',43,'男', 't_10','计算机系','教授',3800,300);     

INSERT  INTO T_teacher
VALUES
('t102225','赵伟',38,'男', 't_10','计算机系','副教授',3000,260.5);   

INSERT  INTO T_teacher(teaID,teaName,age,sex,deptID,dept,profession,salary)
VALUES
('t156354','王新',33,'女', 't_15','数学系','讲师',2500);

INSERT  INTO T_teacher
VALUES
('t106358','毛翠',51,'女', 't_10','计算机系','教授',4000,289.3); 

INSERT  INTO T_teacher
VALUES
('t156355','李中',55,'女',  't_15','数学系','教授',4200,310.2);   

INSERT  INTO T_teacher(teaID,teaName,age,sex,deptID,dept,profession,salary)
VALUES
('t186585','孙立',48,'男', 't_18','物理系','讲师',3200);

INSERT  INTO T_teacher
VALUES
('t181585','李慧',40,'女', 't_18','物理系','教授',3500,278);    

INSERT  INTO T_teacher(teaID,teaName,age,sex,deptID,dept,profession,salary)
VALUES
('t105320','于波',28,'男', 't_10','计算机系','讲师',2800);

******************************************************************
/*创建院校信息表*/
CREATE TABLE T_dept (
deptID  VARCHAR (15) PRIMARY KEY,
deptName VARCHAR (10)  NOT NULL
)

CREATE TABLE T_dept (
deptID  VARCHAR (15) UNIQUE,
deptName VARCHAR (10)  NOT NULL
)

/*向院校信息表插入一条信息*/
select * from  T_dept
INSERT  INTO T_dept
VALUES
('t_10','计算机系')

INSERT  INTO T_dept
VALUES
('t_15','数学系')

INSERT  INTO T_dept
VALUES
('t_18','物理系')

********************************************************************
/*创建计算机系教师信息表*/
CREATE TABLE T_CSteacher (
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 VARCHAR (10) ,
salary  INT  NOT NULL,
pension DOUBLE
)

/*向计算机系教师信息表中插入一条信息*/
INSERT  INTO T_CSteacher
VALUES
('t103265','张昌',43,'男', 't_10','计算机系','教授',3800,300);     

INSERT  INTO T_CSteacher
VALUES
('t102225','赵伟',38,'男', 't_10','计算机系','副教授',3000,260.5);   

INSERT  INTO T_CSteacher
VALUES
('t106358','毛翠',51,'女', 't_10','计算机系','教授',4000,289.3); 

INSERT  INTO T_CSteacher (teaID,teaName,age,sex,deptID,dept,profession,salary)
VALUES
('t105320','于波',28,'男', 't_10','计算机系','讲师',2800);
*************************************************************