paip.语义分析--单字词形容词表180个
INSERT INTO t (word) SELECT DISTINCT word FROM `word_main` where tsisin is not null and tsisin like '%adj%' and LENGTH(word)=3 order by CONVERT(word USING gbk) ASC
limit 10000
mysq按照拼音排序
排除重复
select * from t_n where word in (SELECT word from t) or word in (SELECT word from t_a)
total 180
矮,暗,白,棒,饱,背,笨,扁,瘪,薄,长,迟,冲,愁,稠,丑,臭,纯,蠢,次,粗,错,大,呆,淡,低,冻,陡,逗,毒,堵,对,多,恶,饿,乏,烦,方,肥,粉,疯,富,干,鼓,乖,怪,鬼,贵,憨,好,黑,狠,糊,花,滑,坏,慌,灰,昏,浑,混,火,急,假,紧,靓,绝,倔,渴,空,苦,狂,亏,困,辣,懒,烂,滥,冷,凉,亮,烈,绿,乱,麻,满,慢,忙,美,闷,猛,密,难,孬,嫩,腻,浓,暖,胖,皮,偏,贫,平,破,浅,强,巧,轻,清,晴,穷,全,热,柔,软,弱,骚,臊,涩,傻,少,深,神,湿,瘦,熟,帅,爽,死,酥,俗,酸,损,贪,烫,疼,甜,铁,痛,秃,土,旺,温,稀,细,鲜,咸,香,响,像,小,新,腥,凶,雄,熊,羞,虚,严,艳,痒,野,阴,硬,圆,远,晕,脏,糟,早,粘,正,直,肿,重,皱,壮,准,紫,醉,
INSERT INTO t (word) SELECT DISTINCT word FROM `word_main` where tsisin is not null and tsisin like '%adj%' and LENGTH(word)=3 order by CONVERT(word USING gbk) ASC
limit 10000
mysq按照拼音排序
排除重复
select * from t_n where word in (SELECT word from t) or word in (SELECT word from t_a)
total 180
矮,暗,白,棒,饱,背,笨,扁,瘪,薄,长,迟,冲,愁,稠,丑,臭,纯,蠢,次,粗,错,大,呆,淡,低,冻,陡,逗,毒,堵,对,多,恶,饿,乏,烦,方,肥,粉,疯,富,干,鼓,乖,怪,鬼,贵,憨,好,黑,狠,糊,花,滑,坏,慌,灰,昏,浑,混,火,急,假,紧,靓,绝,倔,渴,空,苦,狂,亏,困,辣,懒,烂,滥,冷,凉,亮,烈,绿,乱,麻,满,慢,忙,美,闷,猛,密,难,孬,嫩,腻,浓,暖,胖,皮,偏,贫,平,破,浅,强,巧,轻,清,晴,穷,全,热,柔,软,弱,骚,臊,涩,傻,少,深,神,湿,瘦,熟,帅,爽,死,酥,俗,酸,损,贪,烫,疼,甜,铁,痛,秃,土,旺,温,稀,细,鲜,咸,香,响,像,小,新,腥,凶,雄,熊,羞,虚,严,艳,痒,野,阴,硬,圆,远,晕,脏,糟,早,粘,正,直,肿,重,皱,壮,准,紫,醉,