The maximum length of colum can have a mysql table ?

Answer 1

Are you asking the maximum amount of columns sql table can have? Or maximum length of sql column?

If first, 4096 columns

If second, it depends on the type your column has

Answer 2

according to google:
MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns because the total length of all columns cannot exceed this size.

Answer 3

Arif Nasery , Shouldn't cause any problems in a long time....

Answer 4

What is your suggestion? I want to add a column to my database every month in order to record the student's fee in a dynamic way. Will not cause problems in the future.

Answer 5

In one year just 12 column for a table will added dynamically.
and the type of data is tinyint

Answer 6

#Aleksi
If u know a good desing for a fees paying system in MySQL can help me ?