UPDATE ptop_investrecord set delflag = 1 where id in (SELECT o.id from (SELECT uid,min(id) as id,count(uid) as num from ptop_investrecord where cid = 1578 and progress = 1 and comefrom = ‘5‘ AND delflag = 0 GROUP BY uid,flagname,money HAVING num >1) as o);
只对老的数据进行更改