mysql中有多少个最大联接表?以及如何计算呢? [英] how many max join table at mysql? and how to count it?

问题描述

也许这个问题与这个问题. 我有问题.. 我的朋友说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 :

单个联接中可以引用的最大表数 是61.这也适用于可以 在视图的定义中引用.

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.

是真的吗? 然后，例如: 我有选择查询并加入2表: 在b.id = a.b_id上左加入a 那么，如何计算联接表的数量呢? 每桌?还是每次加入? 因此，该查询标记为1(每个联接)还是2(每个表)?每个表还是每个连接61个(最大限制)?

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?

推荐答案

有关该文本的内容很清楚:表的最大数量为61".紧随其后的是这也适用于视图中的表数".

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".

这篇关于mysql中有多少个最大联接表?以及如何计算呢?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！