Is there any way to join in the mysql connection condition and the where execution order? Or document

CodePudding user response:

Inner join is the same, left the join can refer to the mysql directly select statement execution order, join match first, then the where filtering,

CodePudding user response:

reference 1st floor chengangcsdn response:

inner join is the same, left the join can refer to the mysql directly select statement execution order, join match first, then the where filtering,

What is the test method to prove or document to indicate this?

CodePudding user response:

The explain extended statement after watching
Show warnings