Page 1 of 1

how many fields can be in a table ??

Posted: Wed Mar 14, 2007 7:15 am
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 !!

Posted: Wed Mar 14, 2007 7:40 am
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.

Posted: Wed Mar 14, 2007 8:50 am
by veridicus
It's completely dependent on the database you're using. As Xoligy points out you need to look at the documentation.