Re: [PHP] MySQL limitations

[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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php