mysql学生选课

老是忘记细节，特别是主外键的建立过程

create table student(s_id int primary key auto_increment,name varchar(64),class varchar(64));

insert into student values(null,"刘亦菲","模特一班");

insert into student values(null,"邓超","表演一班");

insert into student values(null,"姚明","体育一班");

insert into student values(null,"周杰伦","歌手四班");

insert into student values(null,"高晓松","主持一班");

insert into student values(null,"黎明","表演一班");

 

 

 

create table course(c_id int primary key auto_increment,name varchar(64),credit int);

insert into course values(null,"表演课",2);

insert into course values(null,"艺术课",2);

insert into course values(null,"形体课",3);

insert into course values(null,"小品课",4);

insert into course values(null,"主持课",2);

insert into course values(null,"演讲课",2);

insert into course values(null,"武术课",4);

 

create table studentcourse(sc_id int primary key auto_increment,degree int,s_id int,c_id int,

foreign key(s_id) references student(s_id),foreign key(c_id) references course(c_id));

insert into studentcourse values(null,1,1,3);

insert into studentcourse values(null,2,6,2);

insert into studentcourse values(null,1,4,3);

insert into studentcourse values(null,2,3,5);

insert into studentcourse values(null,1,1,2);