CREATE TRIGGER allLine2 AFTER delete //分别添加 delete,update,insert;一次添加为多个未测试
ON AcLine_sub
BEGIN
UPDATE AcLine SET line_length = (select sum(line_length) from AcLine_sub where AcLine_sub.pid=AcLine.id limit 1),
line_model=(select group_concat(line_model) from AcLine_sub where AcLine_sub.pid=AcLine.id limit 1)
where exists(select * from AcLine_sub where AcLine_sub.pid=AcLine.id);
END;
sqlite 触发器 根据子表多个字段更新生成父表某一字段
最新推荐文章于 2021-07-21 10:34:23 发布