MySql多表差询与子查询
一.数据准备
# 建表
create table department(
id int,
name varchar(20)
);
create table employee(
id int primary key auto_increment,
name varchar(20),
sex enum('male','female') not null default 'male',
age int,
dep_id int
);
# 插入数据
insert into department values
(
原创
2020-09-22 20:04:22 ·
126 阅读 ·
0 评论