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
en 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 i
> 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
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 tab