MySQL Forums
Forum List  »  MySQL for Visual Studio

Re: days between differant transaction
Posted by: Peter Brawley
Date: March 08, 2017 10:03AM

It's most always redundant, so a design mistake, to store a calculated column value. Since 5.7, define it as a GENERATED column, see the manual page for Create/Alter Table. If you can't upgrade to 5.7, consider defining a View with that derived column.

Options: ReplyQuote


Subject
Views
Written By
Posted
254
March 08, 2017 07:20AM
Re: days between differant transaction
134
March 08, 2017 10:03AM


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.