执行DELETE操作前可先执行如下SELECT语句,有助于理解:
SELECT * FROM tdb_goods AS t1
LEFT JOIN (SELECT goods_id,goods_name 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\G
SELECT * FROM tdb_goods AS t1
LEFT JOIN (SELECT goods_id,goods_name 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\G