數(shù)據(jù)如下挖诸，表名video，發(fā)現(xiàn)vid和section_id重復(fù)的數(shù)據(jù)很多安岂，要刪除重復(fù)的數(shù)據(jù)只保留一條
+----------+-----------+------------+
| video_id | vid | section_id |
+----------+-----------+------------+
| 10908 | 284478110 | 528238111 |
| 10909 | 284478110 | 528248111 |
| 10884 | 278748110 | 528048111 |
| 10885 | 278758110 | 528058111 |<-重復(fù)
| 54155 | 278758110 | 528058111 |<-重復(fù)
| 10886 | 278768110 | 528068111 |
| 54156 | 278768110 | 528068111 |
| 10887 | 278778110 | 528078111 |
| 10888 | 282228110 | 528078111 |
| 54157 | 278778110 | 528078111 |
| 54158 | 282228110 | 528078111 |
| 10889 | 282148110 | 528088111 |
| 54159 | 282148110 | 528088111 |
| 10890 | 282158110 | 528098111 |
| 54160 | 282158110 | 528098111 |
| 10891 | 282168110 | 528108111 |
| 54161 | 282168110 | 528108111 |
| 10892 | 282178110 | 528118111 |
| 10893 | 282238110 | 528118111 |
| 54162 | 282178110 | 528118111 |
+----------+-----------+------------+
如果要保留小id的數(shù)據(jù)：
delete a from video a,video b where a.video_id>b.video_id and a.vid=b.vid and a.section_id=b.section_id
eg.
update ms_video a,ms_video b set a.status=0 where a.section_id=b.section_id and a.vid=b.vid and a.`status`=1 and b.`status`=1 and a.video_id<b.video_id; //video_id 為自增id
