[MySQL] MySQL 유일한 항목만 남기고 중복제거
하나를하더라도최선을
2019-09-16 10:56
3,020
0
본문
delete from g5_visit where vi_id in (
select vi_id
from
(select vi_id,
row_number() over (partition by vi_agent, vi_agent order by vi_id desc) as row_num
from g5_visit) a
where a.row_num > 1
);
DELETE n1 FROM app_word n1, app_word n2 WHERE n1.uid > n2.uid AND n1.word = n2.word
DELETE n1 FROM app_word n1, app_word n2 WHERE n1.uid > n2.uid AND n1.word = n2.word AND n1.ctg = n2.ctg; // 중복제거
ALTER TABLE app_word AUTO_INCREMENT=1; // index 초기화
SET @COUNT = 0; //
UPDATE app_word SET uid = @COUNT:=@COUNT+1;
DELETE n1 FROM app_referer n1, app_referer n2 WHERE n1.uid > n2.uid AND n1.HTTP_USER_AGENT = n2.HTTP_USER_AGENT;
ALTER TABLE app_referer AUTO_INCREMENT=1;
SET @COUNT = 0;
UPDATE app_referer SET uid = @COUNT:=@COUNT+1;
댓글목록0