1
Reply

How to save any update in each record in table Employee

Ask a question
ahmed sa

ahmed sa

9y
760
1

Hi Guys I have Employee Table have 10 employee i need any edit in any employee in Employee table

registering in database in another table EmployeeHistory table

Example

EmployeeID  10

EmployeeName adil

Nationality  german

Job Engineer

suppose i changed Naionality from german to italian

registering this changed in another table EmployeeHistory table

How to register only changing in record in another table

what codition i write to take only difference in another table

I need to do that to know what changes ahppen in database every day

please help me


Answers (1)