无限星辰工作室-客户无限互联网动力之源

标题: mysql 查找表字段重复数据 [打印本页]

---

作者: crx349    时间: 2022-5-10 23:06
标题: mysql 查找表字段重复数据
方法1

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

复制代码

方法2：使用别名as

1. 
   
2. select xmspace_name,count(*) as c from xmspace group by xmspace_name having c>1;

复制代码

---

欢迎光临 无限星辰工作室-客户无限互联网动力之源 (https://xmspace.net/)

Powered by Discuz! X3.4