DELETE FROM danger_company_produce WHERE
cp_code IN (
SELECT cp_code FROM (
SELECT cp_code,name,COUNT(*) FROM danger_company_produce
GROUP BY name
HAVING COUNT(*) > 1
) AS a
) LIMIT 10000;
mysql 根据字段删除重复数据 只保留一条
最新推荐文章于 2024-05-16 16:00:23 发布