侧边栏壁纸
  • 累计撰写 793 篇文章
  • 累计创建 1 个标签
  • 累计收到 1 条评论
标签搜索

目 录CONTENT

文章目录

单词入库

Dettan
2022-03-04 / 0 评论 / 0 点赞 / 102 阅读 / 207 字
温馨提示:
本文最后更新于 2022-07-23,若内容或图片失效,请留言反馈。部分素材来自网络,若不小心影响到您的利益,请联系我们删除。
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;
0

评论区