I am new to mysql, I have two table employee and audit
-
employee Table have 4 columns
- id
- name
- sal
- role
-
audit Table have 7 columns
- id
- type
- old_value
- new_value
- date
- username
Here , I want to insert 3 rows in audit table if someone add one row in employee table. To maintain the history
for eg: I made an entry in employee table
John | 20,000 | anaylst
Than my audit table will be
Type | old_value |new_value | date | username
name| |John | 01/04/2015 | dummy1
sal| |20,000 | 01/04/2015 | dummy1
role | |anaylst | 01/04/2015 | dummy1
I am unable to insert rows in audit table.