mysql 数据去重

update ptop_investrecord set delflag = 1 where cid  = 250 and uid = 92569  and delflag = 0 and progress = 1 and comefrom = '5' and ptopRecordId = '253274'
and id not in (select tmp.myid FROM (SELECT min(id) as myid from  ptop_investrecord as tmp where cid  = 250 and uid = 92569  and delflag = 0 and progress = 1 and comefrom = '5' and ptopRecordId = '253274') as tmp);

 

标红的一定要加,创建临时表,不然mysql报错  You can't specify target table 'user' for update in FROM clause