sqlite> CREATE TRIGGER "NewTrigger" AFTER INSERT ON "runRecord"
BEGIN
update user set totalDistance =totalDistance+new.runningDistance where username=new.username;
END
;;(这里注意!!!;;)
sqlite 建立触发器
最新推荐文章于 2024-07-02 09:19:44 发布
sqlite> CREATE TRIGGER "NewTrigger" AFTER INSERT ON "runRecord"
BEGIN
update user set totalDistance =totalDistance+new.runningDistance where username=new.username;
END
;;(这里注意!!!;;)