Shulou(Shulou.com)06/01 Report--

This article is about how connections are implemented in mysql. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

The connection is divided into inner connection, outer connection and cross connection. Today we're going to learn how to make internal connections using MySQL.

Inner join definition: only the rows in the two tables that meet the join criteria are combined as the result set.

Key words: INNER JOIN

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

Equivalent to

Select * from employees edepartment d where e.employee_id = d.department_id and e.employee_id = "1"; thank you for reading! On how to achieve the connection within the mysql to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.