去除mysql里面重复的行并留下id最小的

DELETE FROM wynews

WHERE

    title IN (SELECT

        *

    FROM

        (SELECT

            title

        FROM

            wynews

        GROUP BY title

        HAVING COUNT(title) > 1) t1)

    AND Id NOT IN (SELECT

        *

    FROM

        (SELECT

            MIN(Id)

        FROM

            wynews

        GROUP BY title

        HAVING COUNT(title) > 1) t2)