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" <[EMAIL PROTECTED]> 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 > http://www.upscene.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
