delete的触发器要怎么写

[seven_11]

DELIMITER //
DROP TRIGGER IF EXISTS TRG_DELETE_ACCOUNT //
CREATE TRIGGER TRG_DELETE_ACCOUNT BEFORE DELETE ON _record FOR EACH ROW
BEGIN
  UPDATE _account SET balance=balance-NEW.mark*NEW.money WHERE userid=NEW.userid AND account=NEW.account;
END;
//
DELIMITER ;

这样写不行，我想要实现的是，在record表进行删除操作成功后 在account表进行更新操作

[WWWWA]

UPDATE _account SET balance=balance-old.mark*old.money WHERE userid=old.userid AND account=old.account;

[WWWWA]

DELIMITER //
DROP TRIGGER IF EXISTS TRG_DELETE_ACCOUNT //
CREATE TRIGGER TRG_DELETE_ACCOUNT after DELETE ON _record FOR EACH ROW
BEGIN
UPDATE _account SET balance=balance-old.mark*old.money WHERE userid=old.userid AND account=old.account;
END;
//
DELIMITER ;

[小小小小周]

insert 有new ;
update 有new,old;
deleted有old;