MySQL-5.7-Nested Join Optimization(嵌套连接优化)

The syntax for expressing joins permits nested joins. The following discussion refers to the join syntax described in Section 13.2.9.2, “JOIN Clause”.

表示连接的语法允许嵌套连接。

The syntax of table_factor is extended in comparison with the SQL Standard.

与SQL Standard相比，table_factor的语法得到了扩展。

The latter accepts only table_reference, not a list of them inside a pair of parentheses.

后者只接受table_reference，而不是圆括号内的列表。

This is a conservative extension if we consider each comma in a list of table_reference items as equivalent to an inner join. For example:

如果我们认为table_reference项列表中的每个逗号等同于一个内部连接，那么这就是一个保守的扩展。例如:

<