mysql 操作

原创
2018/11/30 10:10
阅读数 28

create user sam identified by 'sam';

grant all privileges on . to 'sam'@'%'identified by 'sam' with grant option;

flush privileges ;

mysql重复数据

Select * From 表 Where 重复字段 In (Select 重复字段 From 表 Group By 重复字段 Having Count(*)>1)

Select * From card where dn In (Select dn From card Group By dn Having Count(*)>1)

展开阅读全文
加载中

作者的其它热门文章

打赏
0
0 收藏
分享
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部