mysql内衔接怎样写【MySQL教程】,mysql,内连接

衔接分为：内衔接、外衔接、交织衔接。本日我们来进修一下，如何用MySQL竖立内衔接。

内衔接定义：仅将两个表中满足衔接前提的行组合起来作为效果集。

关键词：INNER JOIN

select * from employees e inner join department d 
on e.employee_id = d.department_id  where e.employee_id = "1";

等价于

select * from employees e,department d 
where e.employee_id = d.department_id and e.employee_id = "1";

以上就是mysql内衔接怎样写的细致内容，更多请关注ki4网别的相干文章！