paip.语义分析--单字名词表 









 INSERT INTO t (word)  SELECT DISTINCT word FROM `word_main` where tsisin is not null and tsisin like 'n%' and LENGTH(word)=3 order by    CONVERT(word USING gbk) ASC

 limit 10000

 

 mysq按照拼音排序





作者Attilax  艾龙，  EMAIL:1466519819@qq.com 

来源：attilax的专栏

地址：http://blog.csdn.net/attilax





排除重复

 select * from t_n where word in (SELECT word from t)  or   word in (SELECT word from t_a)





 total  258 

 

 

 癌,岸,爸,蚌,宝,碑,笔,表,鳖,冰,兵,饼,病,波,步,菜,蚕,舱,槽,草,叉,茶,豺,蝉,厂,巢,车,秤,虫,仇,船,疮,床,词,葱,村,蛋,党,刀,岛,灯,堤,电,店,貂,雕,爹,冬,洞,堆,舵,鹅,恩,法,帆,饭,范,房,菲,肺,坟,粉,粪,风,蜂,佛,钙,杆,肝,缸,钢,港,膏,糕,哥,弓,汞,沟,钩,狗,瓜,官,馆,光,硅,鬼,锅,国,海,汗,河,鹤,虹,猴,湖,花,画,话,火,货,鸡,家,剑,箭,江,姜,奖,酱,胶,角,脚,她,姐,金,京,鲸,酒,剧,军,君,菌,糠,炕,壳,客,课,坑,口,裤,筐,矿,困,蜡,狼,脸,粮,龙,鹿,路,驴,铝,妈,马,蟒,猫,锚,帽,煤,妹,门,们,梦,迷,米,面,膜,墓,脑,你,年,娘,鸟,尿,镍,孽,您,妞,牛,农,奴,女,啪,牌,炮,盆,皮,癖,屁,坡,漆,棋,铅,钱,枪,墙,桥,琴,球,圈,权,拳,犬,券,群,人,乳,蕊,腮,伞,山,绳,事,书,树,霜,水,锁,他,塔,痰,炭,碳,塘,糖,桃,题,体,天,铁,帖,铜,桶,头,图,土,腿,网,胃,我,鞋,锌,信,行,杏,胸,熊,癣,雪,血,牙,烟,盐,眼,爷,油,枣,灶,债,毡,掌,账,浙,针,痣,轴,庄,字,嘴,