MySQL Forums
Forum List  »  MyISAM

Re: Error : Too many columns
Posted by: Peter Brawley
Date: September 19, 2018 09:14AM

I believe the hard limit for InnoDB is 1017, for MySQL otherwise 4096, but really no RDBMS is designed for thousands of columns. I think you have two choices. Fiddle with much else to get your table to work in 5.7. Or redesign, which I thin you will find quicker annd cheaper.

Options: ReplyQuote


Subject
Views
Written By
Posted
1351
September 19, 2018 07:41AM
Re: Error : Too many columns
620
September 19, 2018 09:14AM
487
September 19, 2018 09:48AM
627
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.