current position:Home>What is the difference between MySQL inner connection, left connection and right connection?

What is the difference between MySQL inner connection, left connection and right connection?

2022-02-04 16:48:02 Alibaba cloud Q & A

mysql The inner connection of 、 Left connection 、 What's the difference between right connections ?




Take the answer 1:

Inner join Internal connection , When a join query is made between two tables , Keep only the exact matching result sets in both tables

left join When a join query is made between two tables , All the rows in the left table are returned , Even if there is no matching record in the right table .

right join When a join query is made between two tables , All rows of the right table are returned , Even if there is no matching record in the left table .


copyright notice
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/02/202202041648004797.html

Random recommended