SQL优化（一）建表

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表