MySQL表中的最大列数 [英] Maximum Number of columns in MySQL table

问题描述

我是MySQL的新手.我有几个问题:

I'm fairly new to MySQL. I have a few questions:

1)多少个(最大)编号.的列数可以在MySQL表中创建.

1) How many (maximum) no. of columns can be created in a MySQL Table.

2)多少个(最大)编号.的表可以在MySQL数据库中创建.

2) How many (maximum) no. of tables can be created in a MySQL database.

推荐答案

• 1-每个表大约4,096列.

  • 1- Approximately 4,096 columns per table.

    2-mySQL具有数据库数量没有限制. 基础文件系统可能对表的数量有限制.各个存储引擎可能会强加特定于引擎的约束. InnoDB最多允许40亿张表.

    2-mySQL has no limit on the number of databases. The underlying file system may have a limit on the number of tables. Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables.

    这篇关于MySQL表中的最大列数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！