MySQL limitations

[Mike Mannakee]

Does anyone know what the maximun number of columns I could put in a table
is?? I can't find it in manual. Like, could I have a table with 200,000
columns?

Mike

[Brent Baisley]

You should rethink your data structure if you want to create 200,000
columns. If you need to create that many columns, chances are you are
going to need to add more periodically. That means changing your table
structure which you shouldn't have to do in a well defined schema. I'm
guessing most of those columns would be empty for any given record.

Try changing your columns to rows and have a column that you use as a
row "label" to qualify what data that row holds. This gives you
virtually unlimited elements you can track, you can add new elements
very easily and it's easier to code. From a coding stand point your
just changing one parameter, the data type field.

Hope that leads you in the right direction.


On Monday, July 28, 2003, at 03:09 PM, Mike Mannakee wrote:

> Does anyone know what the maximun number of columns I could put in a
> table
> is?? I can't find it in manual. Like, could I have a table with
> 200,000
> columns?
>
> Mike
>

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577