时间：2021-07-01 10:21:17 帮助过：2人阅读
1,删除数据库中重复的用户名
delete a from user as a, (select min(id) id,name from user group by name ) as b where a.name = b.name and a.id <> b.id;
group by 取出最小的id,然后从表中删除重复数据;
group by name [ having count(id) >1 ]
sql技巧总结
标签：
< 上一篇
C# 操作access db
下一篇 >
No enclosing instance of type Hello is accessible
记住我的登录 忘记密码？
登录
我已阅读用户协议及版权声明
注册
