How to realize the view trigger entity table,
Table has A table has the unit price, B, C table for the view, c. amount=a. b. unit price * number, c. D table stored amount value, when C table changes trigger D table table at the same time,

CodePudding user response:

Changes the amount of C is the number of unit price from A or B, when the two changes to update D