mysql删除重复数据（某一个字段重复）

DELETE
FROM tp_keyword
WHERE enkeyword IN(SELECT
               enkeyword
             FROM (SELECT
                     enkeyword
                   FROM tp_keyword
                   GROUP BY enkeyword
                   HAVING COUNT(enkeyword) > 1) a)
    AND id NOT IN(SELECT
                    *
                  FROM (SELECT
                          MIN(id)
                        FROM tp_keyword
                        GROUP BY enkeyword
                        HAVING COUNT(enkeyword) > 1) b);