去除数据库的重复数据
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);
只对老的数据进行更改
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步