On Mon, 06 Aug 2007 17:16:07 +0200, Matthias Braun wrote:
> Hi,
>
> I have a difficult problem. When I try to create a table I getting an
> error message "1117: too many columns". Well, the table have more than
> 1300 columns, according to
>
> http://dev.mysql.com/doc/refman/5.1/...trictions.html
>
> there is a limit for InnoDB (and probably also MyISAM) tables of 1000
> columns.

The documentation doesn't mention a limit, and a bit of digging shows
that the number of columns a table has is stored in the MyISAM .myi file
in four bytes. That kind of hints that two wasn't big enough. (The
number of blobs, for contrast, is stored in two bytes.)

> Problem - I can't split the table because in that case I have
> to restructure my whole framework. Anybody know's a solution? Probably
> another Storage engine?

Honestly, if you're getting to the point where you have rows even
numbering in the hundreds, much less thousands, you probably ought to be
rethinking the design anyway, Is this some kind of QUALITY_867 kind of
deal that might be better addressed pivoted around vertically and then
joined in?

--
6. I will not gloat over my enemies' predicament before killing them.
--Peter Anspach's list of things to do as an Evil Overlord