Left join in MySQL, right join

Left (outer) Join: The table is the main, which contains all the rows of the left table, and the right table satisfies the recorded data list

Right (outer) join: The table that is the main, contains all the rows of the right table, and the left table satisfies the recorded data list

Cross join: Cartesian product (all possible combinations of rows).

INNER JOIN: A cross combination that satisfies the join condition.

Full outer join:left outer and right outer all rows of the superset.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Left join in MySQL, right join