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 table was created using utilities from MySQL CookBook via mysqlimport.
   mysqlimport --local MyData < Create_Table.sql

Is it limited by physical memory...or a buffer default in the software?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to