MySQL数据库（4）- 多表查询、可视化工具Navicat的使用、设计模式MVC

一、多表查询

       准备工作：创建两张表，部门表（department）、员工表（employee），代码和表格如下：

# 创建表
create table department(
    id int,
    name varchar(20) 
);
create table employee(
    id int primary key auto_increment,
    name varchar(20),
    gender enum('male','female') not null default 'male',
    age int,
    dep_id int
);

# 插入数据
insert into department values
(200,'技术'),
(201,'人力资源'),
(202,'销售'),
(203,'运营');

insert into employee(name,gender,age,dep_id) values
('egon','male',18,200),
('alex','female',48,201),
('wupeiqi','male',38,201),
('yuanhao','female',28,202),
('nvshen','male',18,200),
('xiaomage','female',18,204);

代码

id	name		id	name	gender	age	dep_id
200	技术		1	egon	male	18	200
201	人力资源		2	alex	female	48	201
202	销售		3	wupeiqi	male	38	201
203	运营		4	yuanhao	female	28	202
			5	nvshen	male	18	200
			6	xiaomage	female	18	204