what is the number of columes i can create in one table? there is a limit?

thnx

The absolute maximum is 4096, but Zymic might impose extra limitations, and that's probably 4096 1 character columns. Why? How many do you want to have? There's a reasonable discussion about it here.

swordz

4096 is the hardcoded limit, if you've got a table that exceeds (or gets anywhere close!) you should really re-think your database design, have a look into database normalisation : http://dev.mysql.com/tech-resources/articl...malization.html

emmm..thats weird.
i tried to create a table with 18 columes but it didn't succeed =\
but sometimes if i change some columes its work...for example:
its work when I changed from "percents varchar(25)" to "something text" O_o
maybe its my mistke?
thank you very much for helping me =]

What exactly did you try? And the phpadmin has been having issues recently.

swordz

no matter...
finally i succeeded access the phpmyadmin

thanks for the help =]