建立联系表:
学院表:
create table `department`(
`id` int primary key auto_increment,
`name` varchar(20) not null
);
学生表:
create table `student`(
`s_id` int primary key auto_increment,
`name` varchar(20) not null,
`dep_id` int,
foreign key(`dep_id`) references `department`(`id`)
);
学生信息表:
create table `stu_details`(
`s_id` int primary key,
`age` int,
`sex` char(1),
foreign key(`s_id`) references `student` (`s_id`)
);
课程表:
create table `course`(
`id` int primary key auto_increment,
`name` varchar(20) not null
);
创建中间表:
create table `course_details`(
`s_id` int,
`c_id` int,
primary key (s_id,c_id),
foreign key (`s_id`) references `student`(`s_id`),
foreign key (`c_id`) references `course`(`id`)
);
查看创建的五张表:
给每个表插入数据:
表的查询操作
查询所有记录:
select * from [表名];