Home / General Questions / Question No: 14

I need information for maximum number of columns in a table in MySQL with different engines. How can I get it?

As of our understanding, The maximum number of columns for any storage engine depends upon the option "AVG_ROW_LENGTH". If your length of the column name is large, then number of columns will be less and obviously vice-versa also holds true.

The options MAX_ROWS * AVG_ROW_LENGTH will decide the maximum tablesize.

To get the current values, use;

SHOW TABLE STATUS LIKE 'tablename';