一、demo脚本
SET @trigger_fieldid=(SELECT fieldid FROM ld_field WHERE tablename='ld_contactrecords' AND columnname='accountid');
SET @effect_fieldid=(SELECT fieldid FROM ld_field WHERE tablename='ld_contactrecords' AND columnname='potentialid');
DELETE FROM ld_related_field WHERE trigger_fieldid=@trigger_fieldid AND effect_fieldid=@effect_fieldid;