月度归档： 2022 年 5 月

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);