I have a table like this:
empid | name | salary
1 | Jack | 25000
2 | Mary | 30000
3 | Jane | 40000
4 | Lary | 50000
I want to create a sql trigger that records the salary update into another seperate table accumlating whatever increase or decrease in the salary column of the employee table. Say if there was a single update for one specific salary column then it records this change however if there were mutiple changes to a salary column then it records all of it together into one column as well. All of this is recorded into a seperate table.
Aucun commentaire:
Enregistrer un commentaire