SQL 练习1

SQL 练习1

一、 建立各种表

1.学生表 Student(SId,Sname,Sage,Ssex)

–SId 学生编号,Sname 学生姓名,Sage 出生年月,Ssex 学生性别

create table student(Sid integer,Sname varchar(20),Sage integer,Ssex varchar(20)) charset=utf8;

insert into student(Sid, Sname,Sage,Ssex) values(1,‘张三’,18,‘男’);
insert into student(Sid, Sname,Sage,Ssex) values(2,‘李四’,19,‘男’);
insert into student(Sid, Sname,Sage,Ssex) values(3,‘王五’,21,‘男’);
insert into student(Sid, Sname,Sage,Ssex) values(4,‘马六’,18,‘男’);
insert into student(Sid, Sname,Sage,Ssex) values(5,‘黛博拉’,18,‘女’);
insert into student(Sid, Sname,Sage,Ssex) values(6,‘伊芙’,20,‘女’);

2.课程表 Course(CId,Cname,TId) --CId --课程编号,Cna