今天写了一个触发器:
delimiter $
CREATE TRIGGER TR after update ON T
for each row
begin
declare a1 INT;
declare b1 INT;
SELECT A into a1 FROM T;
SELECT B into b1 FROM T;
if b1<50 then update T SET A = b1, B = a1 +b1;
end if;
end$
delimiter ;
却出现如下的错误
Can't
solution:
注意mariadb/mysql中触发器中定义变量不能以@开头,赋值方式有:
set,into,建议使用into赋值