一个表中正常有几个字段? [英] How many fields is normal to have in one table?

问题描述

好，我正在创建一个游戏，我有一张桌子，在其中保存了有关会员的很多信息，因此其中有很多字段.一个表中正常有几个字段?有关系吗?也许我应该将该信息拆分为2到3的表?你觉得呢?

Ok, I am creating a game, I have one table where I save a lot of information about a member, so I have many field in it. How many fields is normal to have in one table? Does it matter? Maybe I should split that info into two-three-four tables? What do you think?

推荐答案

规范化数据库

如果您觉得列太多，则可能有重复组，这建议您对数据库进行规范化.在此处查看示例:数据库标准化基础知识的描述

Normalize the Database

If you feel you have too many columns, you probably have repeating groups, which suggests you should normalize the database. See an example here: Description of the database normalization basics

MySQL 5.5 列数限制

MySQL 5.5 Column Count Limit

每个表的最大行大小为65,535字节.

Every table has a maximum row size of 65,535 bytes.

硬限制为4096列 每张桌子

There is a hard limit of 4096 columns per table

这篇关于一个表中正常有几个字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！