MySql 聚合DBchange

1.多字段更新查寻

UPDATE task_job_20210422 t,( SELECT min( id ) AS id,pool_config_id, md5 FROM task_job_20210422 GROUP BY pool_config_id, md5 HAVING count( 1 ) > 1 ) t2 
SET t.is_delete = 1 
WHERE
  t.id != t2.id and t.pool_config_id=t2.pool_config_id and t.md5=t2.md5
  and t.product_status=1 

2.单字段 去重查询

select job_unique_id, title,create_time,update_time,resource_id from task_job_20210422  where job_unique_id in (SELECT job_unique_id FROM task_job_20210422 GROUP BY job_unique_id HAVING COUNT(job_unique_id)>1 ) order by job_unique_id;