Re: Too Many Columns ERROR 175..

2003-11-06 Thread Mike Kuhnkey
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

Too Many Columns ERROR 175..

2003-11-01 Thread Mike Kuhnkey
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