MySQL Forums
Forum List  »  MyISAM

Re: Error : Too many columns
Posted by: Peter Brawley
Date: September 19, 2018 12:45PM

Gas-guzzling diesel cars worked perfectly in their time, it doesn't follow that one should use one now.

Read https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html and https://dev.mysql.com/doc/refman/5.7/en/myisam-table-formats.html. Then see the checked answer at https://dba.stackexchange.com/questions/3972/error-code-1117-too-many-columns-mysql-column-limit-on-table. Read the other answers too, esp. Rick James's.

You may be able to find a set of fiddles that will let you create and even populate the table in 5.7, but performance will be terrible. Time to redesign.



Edited 1 time(s). Last edit at 09/19/2018 12:45PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
2540
September 19, 2018 07:41AM
1088
September 19, 2018 09:14AM
876
September 19, 2018 09:48AM
Re: Error : Too many columns
1129
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.