MySQL 数据去重合并(2)

结合实际场景

双检论文,只给予一个奖励.

一.首先查询出哪些论文题目是重复的

select ywlwtm from xslwk group by ywlwtm having count(*)>1;

二.设计表,插入列重复情况"cfqktest"

UPDATE xslwk set cfqktest = '1' where lwlx = 'SCI' and ywlwtm in  (select ywlwtm from (select ywlwtm from xslwk group by ywlwtm having count(*)>1) t1);
UPDATE xslwk set cfqktest = '2' where lwlx = 'EI' and ywlwtm in  (select ywlwtm from (select ywlwtm from xslwk group by ywlwtm having count(*)>1) t1);
UPDATE xslwk set cfqktest = '3' where lwlx = 'CPCI' and ywlwtm in  (select ywlwtm from (select ywlwtm from xslwk group by ywlwtm having count(*)>1) t1);

这里强调(mysql 不能update与select联合使用),这里使用中间表的方法来处理mysql的异常情况.

可以查看到SCI重复了1225篇;

                  EI重复了1234篇;

                  CPCI重复了37篇;

故三检论文共计6篇

• SCI.EI 双检共1214篇
• SCI CPCI 双检共17篇
• EI CPCI 双检共26篇
• SCI EI CPCI 三检共6篇