Don't understand the use of the term "New"
Why we use the term New.hire_date instead of referring to this with a diff name
I feel like we have two columns with the same name, and we differentiate between them by using the term "New"
Thanks for reaching out.
NEW keyword is a pseudo-record name that refers to the new table row for insert and update operations in row-level triggers. Its usage is:
NEW.column, where column is the name of a column in the table on which the trigger is defined.
Hope this helps.