DELIMITER //
create trigger T_Upd_Account
before update on account
for each row BEGIN
IF new.credit is null THEN
new.credit : = old.credit ;
END IF;
END;
//
老是报如下错误,请看一下为啥?
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '.cred
it : = old.credit ; END IF;
END' at line 7谢谢了
create trigger T_Upd_Account
before update on account
for each row BEGIN
IF new.credit is null THEN
set new.credit= old.credit ; END IF;
END;
//
DELIMITER //
create trigger T_Upd_Account
before update on account
for each rowBEGIN
IF new.credit is null THEN
SET new.credit = old.credit ;
END IF;
END;
//
DELIMITER //
create trigger T_Upd_Account
before update on account
for each rowBEGIN
IF new.credit is null THEN
set new.credit = old.credit;
END IF;
END//
delimiter ;