I knew I'd sound like an idiot.BUT...
The imported text consists of a 'customer' generated message with large arraysand
since I haven't figured out how to generate arrays in mySQL4.0 each array entry is a
record. Since I'm trying to BULK LOAD the message (with as little intervention as
p
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))
wou
> 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.
As a complete sidenote: WHY 1700 columns??!!
With regards,
Mart
