一、demo脚本
SET @trigger_fieldid=(SELECT fieldid FROM ld_field WHERE tablename='ld_customform13' AND columnname='source_list' LIMIT 1);
SET @effect_fieldid=(SELECT fieldid FROM ld_field WHERE tablename='ld_customform13' AND columnname='projectid' LIMIT 1);
INSERT INTO ld_related_field(fieldtype,trigger_fieldid,effect_fieldid,fromvalue_type,fromvalue_info)
SELECT 'main',@trigger_fieldid,@effect_fieldid,'column','projectid' FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM ld_related_field WHERE trigger_fieldid=@trigger_fieldid AND effect_fieldid=@effect_fieldid);
delimiter;