crx349 发表于 2022-5-10 23:06:44

mysql 查找表字段重复数据

方法1
select xmspace_net_name,count(*) from xmspace group by xmspace_net_name having count(xmspace_net_name)>1;

方法2：使用别名as

select xmspace_name,count(*) as c from xmspace group by xmspace_name having c>1;
页: [1]
查看完整版本: mysql 查找表字段重复数据