mySQL Limitations - Max number of fields

[Anon]

Is there a limit to how many fields/columns you can place in a mySQL database table?

Regards,
David

[Anon]

Yes, there is a limit.
You can have an idea at this url:
http://www.mysql.com/information/crash-me.php
After you click get crash-me, at the end of the comparison table, you will find the answer.
P.S.: read the notes at the beginning of the document.

bye

[Anon]

Interesting to see the limit over 3000, should be enough for what i want to do 😛
Lots of other useful info on there too, great stuff!

Thanks,
David

[[deleted]]

Well, manuals are great stuff.

[Anon]

for your information, i always check manuals and i had already checked the mysql manuals (the html, searchable ones) although i couldnt find that information.