Maximum number of colums in MYSQL table

anyone know?

[curlykarl]

Hi

I am putting together a database driven site and one of the MYSQL tables seems to have a lot of columns in it.

Is there a maximum amount you can have, or a safe amount?

I would hate to spend hours putting all the info in to find out its overloaded etc :(

Thanks

Karl

[jatar_k]

This is the best I could find
How Big Can MySQL Tables Be? [mysql.com]

As far as I know there is no limit on number of columns. How many do you mean when you say a lot?

[curlykarl]

"How many do you mean when you say a lot"

about 40-50 columns

It doesn't sound many but it looks alot when you view it!

Does it sound alot? Is this normal, I am new to MYSQL and the most I have used so far is 5

Thanks

Karl

[grifter]

Check out the data at MySQL's "crash-me" section:

[mysql.com...]

Looks like the latest version can handle ~3400 columns. :)

[curlykarl]

"Looks like the latest version can handle ~3400 columns"

wow...thats a mighty wide table :)

[eaden]

I'd say if you have 3400 columns you are designing your database wrong anyway :)