DELETE FROM
tbl_gold_resource
WHERE
id IN (
select * from
(
SELECT
resource.id
FROM
tbl_gold_resource resource,
( SELECT min( id ) id, phone, job_number FROM tbl_gold_resource GROUP BY phone, job_number HAVING count(*) > 1 ) t2
WHERE
resource.phone = t2.phone
AND resource.job_number = t2.job_number
AND resource.id > t2.id ) a
) ;
mysql 添加唯一键 删除唯一键冲突数据
最新推荐文章于 2024-05-08 02:36:44 发布