Re: MySQL limitations

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