mysql触发器怎么写

BEGIN   

IF new.state  in ('2','3')  then 

  INSERT INTO `userservice`.`ehome_us_green_examine`

(modifydate,modifyuser,brancCode,stateDescription,state,

userID,fromSystemkey,applydate,makeHospitalName,illnessName,

userName,rightsholderName,tranno)

VALUES ( sysdate(), 'manage', old.brancCode, old.stateDescription, new.state,

'', old.fromSystemkey, old.applydate,old.makeHospitalName,old.illnessName,

old.userName,old.rightsholderName, old.tranno);

END IF; 

END