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]
