清洗数据的mysql语句

1.查找表中多余的重复记录

select * from t_assessment_consult_apply t where (t.apply_mobile) in (select apply_mobile from t_assessment_consult_apply group by apply_mobile having count(*) > 1)

2.删除重复数据保留一条最新的

DELETE FROM scp_signature_info_record WHERE id not in (select id from (select max(id) AS id from scp_signature_info_record group by project_id, user_id, template_code) a)

3.根据A表的字段值；更新B表

update `scp_grant_credit_card_record` g, `scp_grant_credit_apply_node` n set g.`idcard_no` = n.`idcard_no` where g.`user_id` = n.`user_id`;