0
 Delimiter$$
 create trigger salary_delete
 before delete
 on salary
 for each row begin
 insert into salary_dele(eid,validfrom,amount)
 value(old.eid,old.validfrom,old.amount);
 end if;
 end$$
 delimeter;

UNABLE TO FIND THE MISTAKE .PLEASE HELP

Ergest Basha
  • 7,870
  • 4
  • 8
  • 28
Ujwal Waderaa
  • 1
  • There is no IF to match the end if;? – P.Salmon May 17 '22 at 10:16
  • Change `delimeter;` to `delimiter;` and remove end if as previous comment mentioned https://www.db-fiddle.com/f/6LMbhugzVigtcxJzVkCVLs/0 . Please check https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html for more details – Ergest Basha May 17 '22 at 10:21

1 Answers1

0

Simply

create trigger salary_delete
 before delete
 on salary
 for each row 
 insert into salary_dele(eid,validfrom,amount)
 value(old.eid,old.validfrom,old.amount);

Single-statement compound statement does not need in BEGIN-END and DELIMITER.

Akina
  • 39,301
  • 5
  • 14
  • 25