Skip to content

Commit 0b329e1

Browse files
zhangxiaoqqizhangxiaoqqi
committed
sql删除重复数据
1 parent e8c4c51 commit 0b329e1

File tree

1 file changed

+4
-0
lines changed

1 file changed

+4
-0
lines changed

‎mysql开发技巧二/如何处理重复数据

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -31,3 +31,7 @@ select DepartmentID,DepartmentName from BasicDepartment group by DepartmentID
3131

3232

3333
***********************************************************************************************
34+
更复杂的重复删除：属性中有相同的字段
35+
1、想将属性通过单列转多行得到新的表
36+
2、再删除重复数据
37+
3、再利用GROUP BY CONCAT回复成原表

0 commit comments

Comments
 (0)