1.
先搜索 间隔 统一换成4个空格
2.
' 替换成 \'
3.
执行宏 0iinsert into e4(word,meaning) value('jklf i',jklwi'jk$a');jkj
4.
'\s*' 替换成 '
5.
;' 替换成 ;
6.
# 删除完全重复的
delete from e4 where id in (select id from (select b.id id from e4 a join e4 b on a.word=b.word and a.meaning=b.meaning and a.id!=b.id and a.id<b.id )temp);
# 看完全重复的
select * from e4 a join e4 b on a.word=b.word and a.meaning=b.meaning and a.id!=b.id and a.id<b.id;
# select 多义词
select *,count(meaning) count,group_concat(meaning,' | ') mean from e4 group by word having count(meaning)>1;
# update 多义词
UPDATE e4 join (select *,count(meaning) count,group_concat(meaning,' | ') mean from e4 group by word having count(meaning)>1) b using(word)
SET e4.meaning = b.mean
WHERE
e4.word = e4.word;
# 看总数
select count(*) sum, count(distinct(word)) distinctSum from e4;
评论区