How many Fields??

[kostik]

Hi,

does anybody know how many field can contain a MySQL table? Is there a limit?

Thanks!

Konstantin

[trellie]

basically the limit is the size of your primary key.
if you have an INT(11) UNSIGNED as a key you'd be able to use 99999999999 number of records... (wich is huge! 🙂)

[kostik]

I'm talking about Columns, not rows...

[Anon]

Then see mysql.com

[lth2h]

I suspect you've found the answer by now, but the answer can be found http://www.mysql.com/information/crash-me.php

I would never have found it unless another poster on this site had mentioned it. (http://www.phpbuilder.com/forum/archives/5/2001/5/4/12481)