MySQL Forums
Forum List  »  MyISAM

Error : Too many columns
Posted by: Ian Konda
Date: September 19, 2018 07:41AM

I recently upgraded the mySQL database from version 4.xx to 5.7. I recently started working on mySQL (not my area of expertise as oracle or mssql)

I get quarterly updates from a source which has more than 2000 columns in it. It works fine on older version of mySQL when the table gets created with more than 2000 columns. But the same doesn't work on the version 5.6.Yes I know, it's not a good design. Unfortunately We don't have time and budget to re-design the database.

Any help is appreciated

Thanks
Ian

Options: ReplyQuote


Subject
Views
Written By
Posted
Error : Too many columns
2541
September 19, 2018 07:41AM
1089
September 19, 2018 09:14AM
876
September 19, 2018 09:48AM
1130
September 19, 2018 12:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.