Adding to a former post ¨¨How to add a new column to a table efficiently?¨
I followed the next post
The post is very very helpful on how to add a column to a table and populate it with the help of another table.
I want to ask a question regarding the future population of this column.This solution is for all the existing rows in table.How can I do an automated process that can populate this column everytime the table is updated?
e.g - lets say the mickey table given on the above link post is now updated from an external source but the columns updated are always without the "months_worked" column added by the helper table.
How can I make sure that each row that is updated from this point forward is also poplulated with the value for the ""months_worked" " column.
Is there an automated process I can run? automated update somehow? automated db procedure?
Thanks in advance!