MYSQL去重

--去重（4月份）
delete    t_ded5_paymentinfos as info from t_ded5_paymentinfos as  info,
(
select id as id from t_ded5_paymentinfos
where  mobile in (select a.mobile  as mobilea  from t_ded5_paymentinfos  a where  a.pay_date<'20100431'  and a.pay_date>'20100400'  and a.status=0 group by  a.mobile      having count(a.mobile) > 1)
and   id not in (select max(b.id)  as bid  from t_ded5_paymentinfos b where   b.pay_date<'20100431' and  b.pay_date>'20100400'  and  b.status=0   group by b.mobile     having count(b.mobile)>1)
)  as temp
where info.id = temp.id