MySQL表结构
//班级表
Create table classes(
C_no int primary key,
C_name varchar(20) not null
);
//学生表
Create table student_(
S_no int primary key,
S_name varchar(20) not null,
c_no int not null);
插入数据
Insert into classes values(1,'信息1班'),(2,'信息2班'),
(3,'信息3班'),(4,'信息4班');
insert into student_ values (1,'Li',1), (2,'Wang',1),(3,'Chen',2),
(4,'Jam',3),(5,'Wu',5);
查询
select *from classes;
select *from student_;
内连接
select * from classes c inner join student_ s on c.C_no=s.c_no;
左外连接 左表为主表
select * from classes c left join student_ s on c.C_no=s.c_no;
右外连接 右表为主表
select * from classes c right join student_ s on c.C_no=s.c_no;