how many fields can be in a table ??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
PHPycho
Forum Contributor
Posts: 336
Joined: Fri Jan 06, 2006 12:37 pm

how many fields can be in a table ??

Post by PHPycho »

This may be a simple question, but i am unknown from the answer.
Can anyone tell the correct answer that
1> how many columns do table can have ?
2> maximum data that one table can hold ?
Thanks in advance to all of you !!
Xoligy
Forum Commoner
Posts: 53
Joined: Sun Mar 04, 2007 5:35 am

Post by Xoligy »

Here.

As for column limit, I guess it's unlimited but if you really have that many columns then you need to rethink your database. I suggest you read up about what's called normal form.
User avatar
veridicus
Forum Commoner
Posts: 86
Joined: Fri Feb 23, 2007 9:16 am

Post by veridicus »

It's completely dependent on the database you're using. As Xoligy points out you need to look at the documentation.
Post Reply