mysql 检查重复索引

WITH X1 AS 
(
 SELECT DISTINCT A.TABLE_SCHEMA,
    TABLE_NAME,index_name,
     GROUP_CONCAT(DISTINCT COLUMN_NAME   ) C
  FROM INFORMATION_SCHEMA.STATISTICS A
    group by TABLE_NAME,index_name  
),
X2 AS (

SELECT C, TABLE_SCHEMA,TABLE_NAME,COUNT(0) COUNT1 
FROM X1  X
    GROUP BY  C, TABLE_SCHEMA,TABLE_NAME
    HAVING  COUNT(0)>1
    )  
    SELECT X1.* 
    FROM  X1 JOIN  X2  ON X1.TABLE_NAME =X2.TABLE_NAME 
    AND  X1.TABLE_SCHEMA  =X2.TABLE_SCHEMA  
     AND X2.C =X1.C