MySQL Data sheet deduplication

Query for the number of elements not repeating

Elements in the query table with a number of elements greater than or equal to 2

SELECT goods_id,goods_name from Tdb_goods GROUP by Goods_name have COUNT (goods_name) >=2;  

Then use the left join to connect the original table with the above query results, delete duplicate records, and keep records with smaller IDs

If you want to keep the same ID for the larger, as shown below

DELETE T1 from Tdb_goods as T1 left JOIN (SELECT Max (goods_id) as Goods_id,goods_name from Tdb_goods GROUP by Goods_name H AVING COUNT (goods_name) >=2) as t2 on t1.goods_name = T2.goods_name WHERE t1.goods_id<t2.goods_id;

MySQL Data sheet deduplication