Mysq 创建联合索引时，如何删除重复记录？

前言

近期在使用Kettle迁移数据时，发现很多数据都出现了索引重复的情况，解决后做个记录

---

提示：以下是本篇文章正文内容，下面案例可供参考

DELETE 
FROM
	T_IC_RADIATION 
WHERE
	id IN (
	SELECT
		* 
	FROM
		(
		SELECT
			id 
		FROM
			T_IC_RADIATION 
		WHERE
			id IN (
			SELECT
				t.id 
			FROM
				T_IC_RADIATION t
				INNER JOIN (
				SELECT
					* 
				FROM
					( SELECT a.COMP_NAME, a.COMP_TYPE, a.BUS_ADDR,a.HEALTH_LICENSE,a.IS_ALTER FROM T_IC_RADIATION a GROUP BY a.COMP_NAME, a.COMP_TYPE, a.BUS_ADDR,a.HEALTH_LICENSE,a.IS_ALTER HAVING COUNT( 1 ) > 1 ) b 
				) c ON t.COMP_NAME = c.COMP_NAME
				AND t.COMP_TYPE = c.COMP_TYPE 
				AND t.BUS_ADDR = c.BUS_ADDR
				AND t.HEALTH_LICENSE = c.HEALTH_LICENSE 
				AND t.IS_ALTER = c.IS_ALTER  
			) 
		-- AND id NOT IN ( SELECT id FROM t_ic_publicplaces a GROUP BY a.COMP_NAME, a.COMP_TYPE, a.BUS_ADDR,a.HEALTH_LICENSE,a.IS_ALTER HAVING COUNT( 1 ) > 1 )
    ) tq 
	);

去除重复记录就好啦，啦啦啦啦啦、、、、、