Mysql Select-join(连接查询)
- 一个业务逻辑使用多个实体数据,多张表连接一起使用
// 老师表
create table join_teacher(
id int primary key auto_increment,
t_name varchar(10),
gender enum('male', 'female', 'secret')
)engine innodb character set uff8;
insert into join_teacher values
(1, '韩信', 'male'),
(2, '李白', 'female'),
(3, '韩非子', 'secret')
(4, '孙武', 'male');
// 班级表
create table join_class(
id int primary key auto_increment,
c_name char(7),
root char(