How many fields is normal to have in a table?


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

Hard MySQL Limits

MySQL 5.5 Column Count Limit

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

There is a hard limit of 4096 columns per table