我可以与MySQL一起加入多少张表? [英] How many tables can I join together with MySQL?

问题描述

我可以将多少张表与MySQL联接在一起?到目前为止，我只参加了3张桌子.最高限额是什么?

How many tables can I join together with MySQL? So far I have only been joining 3 tables. What's the max for this?

推荐答案

从MySQL中的限制>

From Limits in MySQL > Limits of Joins:

单个联接中可以引用的表的最大数量为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.

这篇关于我可以与MySQL一起加入多少张表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！