MySQL Create Trigger Syntax Error near END -

MySQL Create Trigger Syntax Error near END -

when seek , run table/trigger creation script, next error:

error 1064 (42000) @ line 19: have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 'set new.fines_remaining = new.total_fines; end if; end' @ line 5

the next create trigger code causing error:

delimiter // create trigger fines_trigger before insert on pupil each row begin if tuple.fines_remaining > tuple.total_fines set new.fines_remaining = new.total_fines; end if; end; // delimiter ;

i can't figure out why happening, sense syntax fine, it's not since there's error beingness thrown.

edit: after posting notice still have these tuple 'variables' using before figured out 'old' , 'new'. i'm changing them , update momentarily.

you missing then after if condition

delimiter // create trigger fines_trigger before insert on pupil each row begin if new.fines_remaining > old.total_fines set new.fines_remaining = new.total_fines; end if; end; // delimiter ;

also have changed tuple new , old in above trigger, may need adjust logic per need.

mysql syntax triggers