I knew I'd sound like an idiot.....BUT...
The imported text consists of a 'customer' generated message with large arrays....and
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
possible) the 'table' turns out to be +1700 entries.
On Sat, 1 Nov 2003 17:45:41 +0100
"Martijn Tonies" <m.tonies@stripped> wrote:
> > 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,
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
> Upscene Productions
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1