How to declare variable in trigger with MySQL?

MySQL help!! Need a solution to a trigger that is not working!?

• Trying to run a trigger for a time function for a database class , keeps generating syntax errors and have been googling all day for a solution in the SQL manual. Help please! Delimiter $$ create trigger Late after insert on signinout For each row begin If each new.OutTime > 17:30 insert into transaction values (TransactionID, ((int(Time(OutTime)-17:30)/60)+1)*20), description, Date, Receipt, New.`StudentID`) end $$ Delimiter;

• Answer:

  I see a few errors, not sure if I caught them all though (this is untested). See 3 comments in code: Delimiter $$     create trigger Late     after insert on signinout     For each row begin         If new.OutTime > 17:30 THEN -- Removed Each, added Then             insert into transaction             (TransactionID, ((int(Time(OutTime)-17:30)/60)+1)*20),                 description, Date, Receipt, New.`StudentID`); -- Add semicolon         End If; -- Add End If    end $$ Delimiter; The link below has a somewhat similar trigger. It might help you.