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 --课程编号,Cname 课程名称,TId 教师编号
create table Course(Cid varchar(20),Cname varchar(20),Tid varchar(20)) charset=ut