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.*NEW.money WHERE userid=NEW.userid AND account=NEW.account;
END;
//
DELIMITER ;
这样写不行,我想要实现的是,在record表进行删除操作成功后 在account表进行更新操作
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.*NEW.money WHERE userid=NEW.userid AND account=NEW.account;
END;
//
DELIMITER ;
这样写不行,我想要实现的是,在record表进行删除操作成功后 在account表进行更新操作
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.*old.money WHERE userid=old.userid AND account=old.account;
END;
//
DELIMITER ;
update 有new,old;
deleted有old;