MySQL Forums
Forum List  »  InnoDB

Re: Regarding "[Warning] InnoDB: Cannot add field"
Posted by: Peter Brawley
Date: August 02, 2021 11:47PM

If the table design you posted is at all representative of the DDL you have so far, then if it's me, I'd first move to MySQL 8.0, then lay that DDL aside aside and start again with a method that can produce a robust design, eg like that outlined at https://www.artfulsoftware.com/dbdesignbasics.html, aiming at a design that's at least Third Normal Form and can support maintainability and performance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Regarding "[Warning] InnoDB: Cannot add field"
70
August 02, 2021 11:47PM


Sorry, only registered users may post in this forum.

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.