Simple operation of mysql join query

The following mainly brings you the simple operation of mysql join query. I hope these contents can bring you practical use, which is also the main purpose of this article that I edit the simple operation of mysql connection query. All right, don't talk too much nonsense, let's just read the following.

1.innerjoin (internal connection, or equivalent connection)

Select * from table1 inner join table2 on table1.column1= table2.column2

2.left join (left connection)

Select * from table1left join table2 on table1.column1= table2.column2

3.right join (right connection)

Select * from table1 right join table2 on table1.column1= table2.column2

4.select union

Select * from table1left join table2 on table1.column1= table2.column2 union select * from table1 right join table2 on table1.column1= table2.column2

For the above simple operation on the mysql connection query, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.