触发器插入多行数据,字符串逗号分隔

CREATE DEFINER =yfy_cloud@%TRIGGERubulAFTER INSERT ON无标题` FOR EACH ROW BEGIN
DELETE FROM base_userrelation WHERE F_UserId = new.F_Id;
INSERT INTO base_userrelation(F_Id,F_UserId,F_ObjectType,F_ObjectId) SELECT UUID() F_Id,new.F_Id F_UserId,'Position' F_ObjectType,id F_ObjectId FROM base_positions WHERE FIND_IN_SET(id,new.F_PositionId);
END;

CREATE DEFINER = yfy_cloud@% TRIGGER ubul2 AFTER UPDATE ON 无标题 FOR EACH ROW BEGIN
DELETE FROM base_userrelation WHERE F_UserId = new.F_Id;
INSERT INTO base_userrelation(F_Id,F_UserId,F_ObjectType,F_ObjectId) SELECT UUID() F_Id,new.F_Id F_UserId,'Position' F_ObjectType,id F_ObjectId FROM base_positions WHERE FIND_IN_SET(id,new.F_PositionId);
END;
`

posted @ 2023-03-23 11:28  River111  阅读(24)  评论(0)    收藏  举报