mysql的这个update触发器哪里错了?

CREATE DEFINER=root@localhost TRIGGER abc AFTER UPDATE ON zqbp_custom
FOR EACH ROW begin
if new.status=0 then
update zqbp_user set user_pass=NEW.user_pass where user_name=NEW.user_name;
if new.status=1 then
update zqbp_user set user_pass=null where user_name=NEW.user_name;

end;

查看回复