Hi,

As of our understanding, The maximum number of columns for any storage storage engine depends upon the option "AVG_ROW_LENGTH". If you length of the column name is large, then no 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>';

Thanks
ViSolve DB Team.
----- Original Message ----- From: "C K" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, November 29, 2006 6:06 PM
Subject: No of columns in a table


I need information for Maximum no. of columns in a table in MySQL with diff.
engines. Where can I get it?
Thanks and regards,
CPK



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to