新学期开始学习sql,努力学习,天天向上
表格如图片所示
create table student(
sno char(3),
sname char(10),
Ssex varchar(10),
sbirthday datetime,
class char(5),
);
insert into student(sno,sname,Ssex,sbirthday,class)values('108', '曾华', '男', '1977-09-01', '95033');
insert into student(sno,sname,Ssex,sbirthday,class)values('105', '匡明', '男', '1975-10-02', '95031');
insert into student(sno,sname,Ssex,sbirthday,class)values('107', '王丽', '女', '1976-09-01', '95033');
insert into student(sno,sname,Ssex,sbirthday,class)values('101', '李军', '男', '1976-02-20', '95033');
insert into student(sno,sname,Ssex,sbirthday,class)values('109', '王芳', '女', '1975-02-10', '95031');
insert into student(sno,sname,Ssex,sbirthday,class)values('103', '陆君', '男', '1974-06-03', '95031');
输入代码:select * from student;
显示如图所示:
新建一个课程表:如图所示
代码如下:
create table course(
cno char(5),
cname varchar(10),
Tno char(3),
);
insert into course(cno,cname,Tno)values('3-105', '计算机导论', '825');
insert into course(cno,cname,Tno)values('3-245', '操作系统', '804');
insert into course(cno,cname,Tno)values('6-166', '数字电路', '856');
insert into course(cno,cname,Tno)values('9-888', '计算机导论', '825');
在新建一个成绩表:
代码如下:
create table Score(
Sno char(5),
Cno char(5),
Degree decimal(4,1),
);
insert into Score(Sno,Cno, Degree)values('105', '3-245', '86');
insert into Score(Sno,Cno, Degree)values('105', '3-245', '75');
insert into Score(Sno,Cno, Degree)values('109', '3-245', '68');
insert into Score(Sno,Cno, Degree)values('103', '3-105', '92');
insert into Score(Sno,Cno, Degree)values('105', '3-105', '88');
insert into Score(Sno,Cno, Degree)values('109', '3-105', '76');
insert into Score(Sno,Cno, Degree)values('101', '3-105', '64');
insert into Score(Sno,Cno, Degree)values('107', '3-105', '91');
insert into Score(Sno,Cno, Degree)values('108', '3-105', '78');
insert into Score(Sno,Cno, Degree)values('101', '6-166', '85');
insert into Score(Sno,Cno, Degree)values('107', '6-166', '79');
insert into Score(Sno,Cno, Degree)values('108', '6-166', '81');
在新建一个教师表:
代码如下:
create table teacher(
Tno char(3),
Tname char(4),
Tsex varchar(2),
Tbirthday datetime,
Prof char(6),
Depart varchar(10),
);
insert into teacher(Tno,Tname,Tsex,Tbirthday,Prof,Depart)values('804', '李诚', '男', '1958-12-10', '副教授','计算机系');
insert into teacher(Tno,Tname,Tsex,Tbirthday,Prof,Depart)values('856', '张旭', '男', '1969-03-12', '讲师','电子工程系');
insert into teacher(Tno,Tname,Tsex,Tbirthday,Prof,Depart)values('825', '王萍', '女', '1972-05-05', '助教','计算机系');
insert into teacher(Tno,Tname,Tsex,Tbirthday,Prof,Depart)values('831', '刘冰', '女', '1977-08-14', '助教','电子工程系');
问题1:查询Student表中的所有记录的Sname、Ssex和Class列
代码如下:
select sname,Ssex,class from student;