![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
zoupanpan1
这个作者很懒,什么都没留下…
展开
-
sql 查出一张表中重复的所有记录数据
查询重复的数据1.查询出所有数据进行分组之后,和重复数据的重复次数的查询数据,先列下:select count(username) as '重复次数',username from t_user group by username having count(*)>1 order by username desc2.查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断select * from peoplewhere peopleId in (select peopl转载 2020-11-19 17:35:37 · 417 阅读 · 0 评论 -
mysql使用utf8mb4经验总结
mysql使用utf8mb4经验吐血总结utf8 与 utf8mb4 异同The character set named utf8 uses a maximum of three bytes per character and contains only BMP characters. The utf8mb4 character set uses a maximum of four bytes per character supports supplementary characters:- F转载 2020-11-11 14:53:51 · 466 阅读 · 0 评论