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 Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: DDL Severity:S1 (Critical)
Version:5.0.77 OS:Linux
Assigned to: CPU Architecture:Any

[9 Sep 2010 14:12] Ravi Patel
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.