mysql之多表删除

DELETE t1
FROM
    tdb_goods AS t1
LEFT JOIN (
    SELECT
        goods_name,
        goods_id
    FROM
        tdb_goods
    GROUP BY
        goods_name
    HAVING
        count(goods_name) >= 2
) AS t2 ON t1.goods_name = t2.goods_name
WHERE
    t1.goods_id > t2.goods_id;

//删除商品表中存在的重复的数据