删除重复数据只保留一条数据

查找product_id重复的数据

select DISTINCT(product_id) from bas_product GROUP BY product_id having count(*)>1  
                
select DISTINCT(product_id) from bas_product   

SELECT COUNT(*) from bas_product 

product_guid 为该表的唯一标识符，删除product_id 重复的数据

DELETE FROM bas_product
WHERE product_guid NOT IN (
  SELECT min(product_guid)
  FROM bas_product
  GROUP BY product_id
);