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
922
September 19, 2018 07:41AM
Re: Error : Too many columns
478
September 19, 2018 09:14AM
376
September 19, 2018 09:48AM
478
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.