1.建表
建立课程表(Course),教师表(Teacher),教师信息表(TeacherCard)。
CREATE TABLE Course (
ID int(3),
Name varchar(20),
TeacherID int(3)
);
CREATE TABLE Teacher (
ID int(3),
Name varchar(20),
CardID int(3)
);
CREATE TABLE TeacherCard (
ID int(3) ,
Description varchar(50)
);
2.插入数据
向上面三张表中插入相应的数据。
insert into Course values(1,"java",1);
insert into Course values(2,"html",1);
insert into Course values(3,"sql",2);
insert into Course values(4,"web",3);
insert into Teacher values(1,"April",1);
insert into Teacher values(2,"Harris",2);
insert into Teacher values(3,"Dave",3);
insert into TeacherCard values(1,"High");
insert into TeacherCard values(2,"Middle");
insert into TeacherCard values(3,"Low");
3.查看数据
select * from Course;
select * from Teacher;
select * from TeacherCard;
执行结果如下:
Course表
Teacher表
TeacherCard表