mysql下怎么写存储过程和函数？

我的是这样写的：
example：

delimiter //

CREATE TRIGGER `CHRM_OTHERORGMEMBER_AFTER_UPD_TR` AFTER UPDATE ON `CHRM_OTHERORGMEMBER`
FOR EACH ROW
BEGIN

IF NEW.IS_EXIT = 'Yes' THEN
UPDATE CHRM_EMPLOYEE_VIR_ORG SET CHRM_EMPLOYEE_VIR_ORG.QUIT = NEW.IS_EXIT,CHRM_EMPLOYEE_VIR_ORG.EXIT_DATE = NEW.EXIT_DATE
WHERE (OID = NEW.EMPLOYEE_ID) AND (OTHERORGMEMBER_ID = NEW.OTHER_ORG_MEM_ID);
END IF;

END;
//

delimiter ;

你也可以用ＥＭＳ ＳＱＬ Ｍａｎａｇｅｒ．