sqlite 触发器,好像不支持定义变量,
继续关注中。。。
测试:学生表中,年龄字段递增
create trigger if not exists trigger_student
after update on trigger_student
for each row
when new.age < old.age
begin
update table set age = old.age where id = new.id;
end;
参考:
https://www.sqlite.org/lang_createtrigger.html