trigger after delete

[oll3i]

CREATE TRIGGER candidate_delete AFTER DELETE ON candidates
 FOR EACH ROW BEGIN
    INSERT INTO candidates_trash SET ID_CANDIDATE=OLD.ID_CANDIDATE,candidate_status=OLD.candidate_status,job_reference=OLD.job_reference,name=OLD.name,firstname=OLD.firstname,
   qm1=OLD.qm1,qm2=OLD.qm2,qm3=OLD.qm3,civic_status=OLD.civic_status,dob=OLD.dob,yearofbirth=OLD.yearofbirth,
   ph_mob_con=OLD.ph_mob_con,ph_mob=OLD.ph_mob,ph_home_con=OLD.ph_home_con,ph_home_city=OLD.ph_home_city,ph_home=OLD.ph_home,
   ph_work_con=OLD.ph_work_con,ph_work_city=OLD.ph_work_city,ph_work=OLD.ph_work,email_per=OLD.email_per,email_work=OLD.email_work,
   city=OLD.city,province=OLD.province,
   location=OLD.location,origin_app=OLD.origin_app,mobility=OLD.mobility,ID_NUMBER=OLD.ID_NUMBER,candidate_password=OLD.candidate_password,score=OLD.score,
   entered=OLD.entered,enteredby=OLD.enteredby;
  END;

why i get
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO candidates_trash SET ID_CANDIDATE=OLD.ID_CANDIDATE,candidate_status=' at line 3

in mysql 5.0.41


THANK YOU

[oll3i]

ok i solved it :) thank you

[Jankie]

ok i solved it :) thank you

would you mind sharing how did you solve it,please?
just curious :)