List:General Discussion« Previous MessageNext Message »
From:Mike Kuhnkey Date:November 1 2003 4:40pm
Subject:Too Many Columns ERROR 175..
View as plain text  
What is the relationship between "column name length", "Number of columns" and "max

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?
Too Many Columns ERROR 175..Mike Kuhnkey1 Nov
  • Re: Too Many Columns ERROR 175..Martijn Tonies1 Nov
    • Re: Too Many Columns ERROR 175..Mike Kuhnkey7 Nov
  • Re: Too Many Columns ERROR 175..Matt W1 Nov