错误码:1064.你有一个错误在你的SQL语法;检查MySQL对应的手册

Question

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;

找不到错误，请帮忙

Answer 1

简写

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);

单语句复合语句不需要BEGIN-END和DELIMITER。