Re: which table type does not have the maximum columns limitation?

[Brent Baisley]

I think if you are looking for unlimited columns, you may want to 
rethink your database structure. Databases are designed for unlimited 
rows, not columns. Whatever data you were looking to put into unlimited 
columns, should be put into rows in a related table. I usually do this 
by adding a "qualifier" column that describes what data is contained in 
that row. This structure allows unlimited data sets and allows you to 
add new data sets without having to change the structure of a table.
Not knowing your data, I don't know if this is not suitable for any 
particular reason.

On May 18, 2004, at 6:08 PM, Hongyu Sun wrote:
Dear List:
I wonder if there exist a type of table which can allow for unlimited 
or at
least more than 1024 columns? I know MaxDB has 1024 max columns.

Please give me a hint if you could. Thanks in advance!
Hongyu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]