CREATE TRIGGER TR_S_AGE_UPDATE
after update on student
for each row
begin
if new.Sage>15 and new.Sage<45 then
set new.Sage=old.Sage
END if;
end
最后两行end要怎么写,不管加不加;都回报错
加冒号试试
CREATE TRIGGER TR_S_AGE_UPDATE
after update on student
for each row
begin
if :new.Sage>15 and :new.Sage<45 then
set :new.Sage=:old.Sage;
END if;
end
有没有建立student这个数据表呢?
还要看一下这个数据表中有没有Sage这个字段