Bug #56692 I want to store large number of columns, say 7000 !!!!

• Submitted: 9 Sep 2010 14:12
• Modified: 9 Sep 2010 15:50
• Reporter: Ravi Patel
• Status: Not a Bug
• Category: MySQL Server: DDL
• Severity: S1 (Critical)
• Version: 5.0.77
• OS: Linux
• CPU Architecture: Any

[9 Sep 2010 14:12] Ravi Patel

Description:
I have a large matrix.
Say 65,000 x 7,000. Columns may even increase by the time.
I tried to make table for this but I ended up with an error of "Too many columns"...

Isn't there any way to store this data?

I am using 5.0.77 version of mysql.

Or any other database suitable for this.??

Please help me ASAP..

How to repeat:
Any query can be used for the repeating of the bug. Infact I cant give query here as it will be large. Thank you.

Suggested fix:
Or any other RDBMS available for my use??

[9 Sep 2010 15:50] Miguel Solorzano

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.