[SQL]CREATE TRIGGER mytg1
BEFORE INSERT ON personmeney
FOR EACH ROW
BEGIN
DECLARE n INT DEFAULT 0;
-- 查看银行卡里是否有足够的钱
SELECT money INTO n FROM car WHERE id=new.id;
if new.money>n THEN-- 条件开始
SET new.money=n;
END IF;-- 条件结束
UPDATE car SET money=money-new.money WHERE id=new.id;
END;
[Err] 1054 - Unknown column 'money' in 'NEW'
这种情况往往是两张表的列存在问题。
例如:一张表有money,另一张表没有。cu