mysql删除重复数据

create table tmptable as select min(id) as tmp from target_table group by userId;

delete from target_table where id not in (select tmp from tmptable);

查询user_id数量大于1的数据信息

select *,count(user_id) from da_bank_base_user where is_valid = 1 group by user_id having count(user_id)>1;