Hi Mike,
From the last paragraph at
http://www.mysql.com/doc/en/Storage_requirements.html
"The maximum size of a row in a MyISAM table is 65534 bytes. Each BLOB
and TEXT column accounts for only 5-9 bytes toward this size."
I assume from this that a VARCHAR(255) column (or even VARCHAR(10))
would count more towards that limit than a TINYTEXT one, even though
they can store the same amount.
Hope that helps.
Matt
----- Original Message -----
From: "Mike Kuhnkey"
Sent: Saturday, November 01, 2003 10:40 AM
Subject: Too Many Columns ERROR 175..
> What is the relationship between "column name length", "Number of
columns" and "max columns"?
>
> Upon creation of a table with +1700 columns (with approximately
25...30 characters per name) I get the "Too many columns" ERROR.
> If column names are limited to 2 characters the ERROR goes away.
>
> The table was created using utilities from MySQL CookBook via
mysqlimport.
> mysqlimport --local MyData < Create_Table.sql
>
> Is it limited by physical memory...or a buffer default in the
software?
