一个项目mysql多少个表,mysql有多少个最大连接表？以及如何计算？

Maybe this question is related with this one.

I have Question..

My friend said that mysql has limitation on max join table.

And I get this :

The maximum number of tables that can be referenced in a single join

is 61. This also applies to the number of tables that can be

referenced in the definition of a view.

Is that true?

Then, for example:

I have select query and join 2 table:

left join a on b.id = a.b_id

So, how to count the number of joined table?

Per table? or Per join?

so, that query marked as 1 (per join) or 2(per table)? 61 (max limit) is per table or per join?

解决方案

The text is clear on that: "The maximum number of tables [...] is 61". Followed by "This also applies to the number of tables [in] a view".