select value,count(*) as count from catalog_product_entity_varchar
where entity_type_id=4 and attribute_id = 71 and store_id=0
group by value having count>1
mysql查询数据表中是否有重复的数据
最新推荐文章于 2023-06-13 14:35:08 发布
select value,count(*) as count from catalog_product_entity_varchar
where entity_type_id=4 and attribute_id = 71 and store_id=0
group by value having count>1