MySql去重操作

去除MySQL中重复的记录，仅保留其中一条。本例中id 为重复项，而idx 为primary key。

DELETE FROM xr_gc_test_info
WHERE id IN
    (
    SELECT id FROM
                      (
                      SELECT id FROM xr_gc_test_info GROUP BY id HAVING COUNT(id)>1
                      ) t1
    )
AND idx NOT IN
    (
    SELECT idx FROM
                    (
                    SELECT MIN(idx) idx FROM xr_gc_test_info GROUP BY id HAVING COUNT(id)>1
                    ) t2
    )