1)提供数据集id,执行
update card_to_data_source set is_del = 1 where ds_id in ();
2)如果需要排查是否还有其他脏数据,可以执行进行查找
select t.cd_id,t.ds_id,t.ctime as ds_ctime,c.ctime as card_ctime,c.utime as card_utime,c.is_del as card_isdel,t.is_del as relation_isdel, ds.is_del as ds_isdel
from card_to_data_source t
join card c ON c.cd_id = t.cd_id
JOIN data_source ds ON ds.ds_id = t.ds_id
where c.is_del = 1 and t.is_del = 0;