From: Martijn Tonies
Date: November 1 2003 4:45pm
Subject: Re: Too Many Columns ERROR 175..
List-Archive: http://lists.mysql.com/mysql/152877
Message-Id: <013001c3a097$96304ec0$0a02a8c0@seal>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit




> 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