mysql 汉字转拼音直接上手可用

最新推荐文章于 2024-07-03 03:35:11 发布
最新推荐文章于 2024-07-03 03:35:11 发布
阅读量140 收藏
点赞数
分类专栏： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_56062333/article/details/119965913
版权

汉字全拼 数据库 转换函数 拼音 首字母
关键词由CSDN通过智能技术生成

--汉字转全拼

--创建表

create table `t_base_pinyin` (
`pin_yin_` varchar (765),
`code_` int (11)
);
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zuo','10254');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zun','10256');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zui','10260');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zuan','10262');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zu','10270');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zou','10274');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zong','10281');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zi','10296');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhuo','10307');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhun','10309');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhui','10315');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhuang','10322');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhuan','10328');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhuai','10329');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhua','10331');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhu','10519');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhou','10533');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhong','10544');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhi','10587');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zheng','10764');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhen','10780');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhe','10790');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhao','10800');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhang','10815');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhan','10832');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zhai','10838');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zha','11014');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zeng','11018');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zen','11019');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zei','11020');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ze','11024');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zao','11038');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zang','11041');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zan','11045');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('zai','11052');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('za','11055');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yun','11067');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yue','11077');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yuan','11097');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yu','11303');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('you','11324');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yong','11339');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yo','11340');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ying','11358');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yin','11536');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yi','11589');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ye','11604');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yao','11781');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yang','11798');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('yan','11831');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ya','11847');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xun','11861');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xue','11867');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xuan','12039');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xu','12058');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xiu','12067');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xiong','12074');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xing','12089');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xin','12099');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xie','12120');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xiao','12300');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xiang','12320');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xian','12346');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xia','12359');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('xi','12556');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('wu','12585');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('wo','12594');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('weng','12597');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('wen','12607');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('wei','12802');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('wang','12812');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('wan','12829');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('wai','12831');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('wa','12838');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tuo','12849');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tun','12852');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tui','12858');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tuan','12860');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tu','12871');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tou','12875');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tong','12888');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ting','13060');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tie','13063');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tiao','13068');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tian','13076');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ti','13091');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('teng','13095');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('te','13096');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tao','13107');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tang','13120');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tan','13138');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('tai','13147');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ta','13318');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('suo','13326');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sun','13329');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sui','13340');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('suan','13343');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('su','13356');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sou','13359');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('song','13367');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('si','13383');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shuo','13387');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shun','13391');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shui','13395');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shuang','13398');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shuan','13400');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shuai','13404');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shua','13406');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shu','13601');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shou','13611');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shi','13658');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sheng','13831');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shen','13847');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('she','13859');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shao','13870');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shang','13878');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shan','13894');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('shai','13896');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sha','13905');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('seng','13906');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sen','13907');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('se','13910');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sao','13914');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sang','13917');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('san','14083');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sai','14087');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('sa','14090');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ruo','14092');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('run','14094');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('rui','14097');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ruan','14099');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ru','14109');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('rou','14112');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('rong','14122');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ri','14123');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('reng','14125');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ren','14135');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('re','14137');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('rao','14140');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('rang','14145');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ran','14149');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qun','14151');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('que','14159');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('quan','14170');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qu','14345');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qiu','14353');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qiong','14355');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qing','14368');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qin','14379');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qie','14384');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qiao','14399');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qiang','14407');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qian','14429');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qia','14594');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('qi','14630');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pu','14645');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('po','14654');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ping','14663');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pin','14668');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pie','14670');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('piao','14674');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pian','14678');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pi','14857');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('peng','14871');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pen','14873');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pei','14882');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pao','14889');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pang','14894');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pan','14902');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pai','14908');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('pa','14914');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ou','14921');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('o','14922');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nuo','14926');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nue','14928');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nuan','14929');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nv','14930');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nu','14933');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nong','14937');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('niu','14941');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ning','15109');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nin','15110');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nie','15117');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('niao','15119');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('niang','15121');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nian','15128');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ni','15139');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('neng','15140');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nen','15141');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nei','15143');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ne','15144');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nao','15149');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nang','15150');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nan','15153');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('nai','15158');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('na','15165');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mu','15180');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mou','15183');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mo','15362');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('miu','15363');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ming','15369');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('min','15375');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mie','15377');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('miao','15385');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mian','15394');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mi','15408');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('meng','15416');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('men','15419');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mei','15435');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('me','15436');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mao','15448');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mang','15454');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('man','15625');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('mai','15631');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ma','15640');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('luo','15652');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lun','15659');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lue','15661');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('luan','15667');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lv','15681');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lu','15701');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lou','15707');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('long','15878');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('liu','15889');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ling','15903');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lin','15915');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lie','15920');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('liao','15933');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('liang','15944');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lian','15958');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lia','15959');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('li','16155');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('leng','16158');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lei','16169');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('le','16171');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lao','16180');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lang','16187');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lan','16202');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('lai','16205');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('la','16212');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kuo','16216');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kun','16220');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kui','16393');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kuang','16401');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kuan','16403');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kuai','16407');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kua','16412');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ku','16419');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kou','16423');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kong','16427');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('keng','16429');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ken','16433');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ke','16448');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kao','16452');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kang','16459');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kan','16465');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('kai','16470');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ka','16474');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jun','16647');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jue','16657');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('juan','16664');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ju','16689');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jiu','16706');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jiong','16708');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jing','16733');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jin','16915');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jie','16942');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jiao','16970');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jiang','16983');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jian','17185');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('jia','17202');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ji','17417');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('huo','17427');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hun','17433');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hui','17454');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('huang','17468');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('huan','17482');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('huai','17487');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hua','17496');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hu','17676');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hou','17683');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hong','17692');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('heng','17697');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hen','17701');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hei','17703');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('he','17721');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hao','17730');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hang','17733');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('han','17752');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('hai','17759');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ha','17922');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('guo','17928');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gun','17931');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gui','17947');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('guang','17950');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('guan','17961');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('guai','17964');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gua','17970');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gu','17988');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gou','17997');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gong','18012');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('geng','18181');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gen','18183');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gei','18184');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ge','18201');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gao','18211');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gang','18220');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gan','18231');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('gai','18237');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ga','18239');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('fu','18446');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('fou','18447');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('fo','18448');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('feng','18463');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('fen','18478');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('fei','18490');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('fang','18501');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('fan','18518');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('fa','18526');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('er','18696');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('en','18697');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('e','18710');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('duo','18722');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('dun','18731');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('dui','18735');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('duan','18741');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('du','18756');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('dou','18763');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('dong','18773');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('diu','18774');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ding','18783');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('die','18952');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('diao','18961');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('dian','18977');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('di','18996');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('deng','19003');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('de','19006');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('dao','19018');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('dang','19023');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('dan','19038');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('dai','19212');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('da','19218');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cuo','19224');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cun','19227');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cui','19235');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cuan','19238');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cu','19242');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cou','19243');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cong','19249');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ci','19261');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chuo','19263');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chun','19270');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chui','19275');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chuang','19281');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chuan','19288');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chuai','19289');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chu','19467');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chou','19479');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chong','19484');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chi','19500');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cheng','19515');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chen','19525');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('che','19531');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chao','19540');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chang','19715');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chan','19725');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('chai','19728');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cha','19739');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ceng','19741');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ce','19746');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cao','19751');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cang','19756');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('can','19763');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('cai','19774');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ca','19775');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bu','19784');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bo','19805');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bing','19976');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bin','19982');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bie','19986');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('biao','19990');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bian','20002');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bi','20026');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('beng','20032');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ben','20036');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bei','20051');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bao','20230');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bang','20242');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ban','20257');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('bai','20265');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ba','20283');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ao','20292');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ang','20295');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('an','20304');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('ai','20317');
insert into `t_base_pinyin` (`pin_yin_`, `code_`) values('a','20319');

--创建函数

DELIMITER $$

USE `pbq`$$

DROP FUNCTION IF EXISTS `to_pinyin`$$

CREATE DEFINER=`root`@`%` FUNCTION `to_pinyin`(NAME VARCHAR(255) CHARSET gbk) RETURNS VARCHAR(255) CHARSET gbk
BEGIN
DECLARE mycode INT;
DECLARE tmp_lcode VARCHAR(2) CHARSET gbk;
DECLARE lcode INT;

DECLARE tmp_rcode VARCHAR(2) CHARSET gbk;
DECLARE rcode INT;

DECLARE mypy VARCHAR(255) CHARSET gbk DEFAULT '';
DECLARE lp INT;

SET mycode = 0;
SET lp = 1;

SET NAME = HEX(NAME);

WHILE lp < LENGTH(NAME) DO

SET tmp_lcode = SUBSTRING(NAME, lp, 2);
SET lcode = CAST(ASCII(UNHEX(tmp_lcode)) AS UNSIGNED);
SET tmp_rcode = SUBSTRING(NAME, lp + 2, 2);
SET rcode = CAST(ASCII(UNHEX(tmp_rcode)) AS UNSIGNED);
IF lcode > 128 THEN
SET mycode =65536 - lcode * 256 - rcode ;
SELECT CONCAT(mypy,pin_yin_) INTO mypy FROM t_base_pinyin WHERE CODE_ >= ABS(mycode) ORDER BY CODE_ ASC LIMIT 1;
SET lp = lp + 4;
ELSE
SET mypy = CONCAT(mypy,CHAR(CAST(ASCII(UNHEX(SUBSTRING(NAME, lp, 2))) AS UNSIGNED)));
SET lp = lp + 2;
END IF;
END WHILE;
RETURN LOWER(mypy);
END$$

DELIMITER ;

--汉字首字母转拼音

DELIMITER $$

USE `pbq`$$

DROP FUNCTION IF EXISTS `getPY`$$

CREATE DEFINER=`root`@`%` FUNCTION `getPY`(in_string VARCHAR(21845)) RETURNS VARCHAR(21845) CHARSET utf8
BEGIN
DECLARE tmp_str VARCHAR(21845) CHARSET gbk DEFAULT '' ;
DECLARE tmp_len SMALLINT DEFAULT 0;
DECLARE tmp_loc SMALLINT DEFAULT 0;
DECLARE tmp_char VARCHAR(2) CHARSET gbk DEFAULT '';
DECLARE tmp_rs VARCHAR(21845)CHARSET gbk DEFAULT '';
DECLARE tmp_cc VARCHAR(2) CHARSET gbk DEFAULT '';
SET tmp_str = in_string;
SET tmp_len = LENGTH(tmp_str);
WHILE tmp_len > 0 DO
SET tmp_char = LEFT(tmp_str,1);
SET tmp_cc = tmp_char;
SET tmp_loc=INTERVAL(CONV(HEX(tmp_char),16,10),0xB0A1,0xB0C5,0xB2C1,0xB4EE,0xB6EA,0xB7A2,0xB8C1,0xB9FE,0xBBF7,0xBFA6,0xC0AC,0xC2E8,0xC4C3,0xC5B6,0xC5BE,0xC6DA,0xC8BB,0xC8F6,0xCBFA,0xCDDA ,0xCEF4,0xD1B9,0xD4D1);
IF (LENGTH(tmp_char)>1 AND tmp_loc>0 AND tmp_loc<24) THEN
SELECT ELT(tmp_loc,'A','B','C','D','E','F','G','H','J','K','L','M','N','O','P','Q','R','S','T','W','X','Y','Z') INTO tmp_cc;
END IF;
SET tmp_rs = CONCAT(tmp_rs,tmp_cc);
SET tmp_str = SUBSTRING(tmp_str,2);
SET tmp_len = LENGTH(tmp_str);
END WHILE;
RETURN tmp_rs;
END$$

DELIMITER ;

金灿灿的
关注
专栏目录
MySQL面试题 2024 金九银十 最新 C# 高级 资深 DB 八股文
cao919的专栏Net
08-13 807
聚集索引表记录的排列顺序和索引的排列顺序一致，所以查询效率快，只要找到第一个索引值记录，其 余就连续性的记录在物理也一样连续存放。聚集索引对应的缺点就是修改慢，因为为了保证表中记录的 物理和索引顺序一致，在记录插入的时候，会对数据页重新排序。中的慢查询问题，提高数据库系统的性能。树结 构，非聚集索引的叶子层并不和实际数据页相重叠，而采用叶子层包含一个指向表中的记录在数据页中 的指针方式。上表所示的用户信息遵循了第一范式的要求，这样在对用户使用城市进行分类的时候就非常方便，也提 高了数据库的性能。
参考文献
热门推荐
Ω｜狐步幻影
10-26 7万+
[ IIS 6 = php 5 + MySQL 5 ]body { font-family:verdana; cursor:default;}td {font-size:14px;color:darkslategray;line-height:150%}a:link {color:whitesmoke}a:hover {color:silver}a:visited
Mysql中文汉字转拼音的实现（每个汉字转换全拼）
12-15
一、创建拼音对照表 代码如下:— 创建汉字拼音对照临时表CREATE TABLE IF NOT EXISTS `t_base_pinyin` (  `pin_yin_` varchar(255) CHARACTER SET gbk NOT NULL,  `code_` int(11) NOT NULL,  PRIMARY KEY (`code_`)) ENGINE=InnoDB DEFAULT CHARSET=latin1; 二、插入对照数据 代码如下:— 插入数据INSERT INTO t_base_pinyin (pin_yin_,code_)  VALUES (“a”, 20319)
mysql更新汉字为拼音
最新发布
weixin_32506761的博客
07-03 91
数据库相关视频讲解：用python编程Excel有没有用处？从MySQL数据库中更新汉字为拼音的方法 在实际的开发过程中，我们可能会遇到需要将数据库中存储的中文字符转换为拼音的需求。这种需求可能是为了提高检索的效率，也可能是为了方便用户阅读和搜索。在MySQL数据库中，我们可以通过使用函数来实现这一目的。本文将介绍如何使...
MySQL数据库汉字转拼音全拼(大写、小写、拼音首字母)函数和ELT(INTERVAL(CONV(HEX(LEFT(CONVERT方式实现转拼音
后端开发
06-01 2462
本文介绍mysql使用函数将中文转为拼音，包括大写拼音、小写拼音、拼音首字母等
mysql 中文转拼音
zhen340417593的专栏
05-24 876
mysql 中文转拼音
在MySQL中获取中文的拼音或转换中文为拼音
二十七八岁
11-20 789
MySQL ------------------------------------- 分页：select * from xxx limit 0,10         limit start,pagesize   -------------------------------------   INSERT INTO person_info   SELECT   u.uid, ...
coreseek-3.2.14
11-15
2. **中文支持**：与Sphinx相比，CoreSeek强化了对中文的支持，包括分词、同义词处理、拼音转换等功能，使得中文搜索体验更佳。 3. **实时更新**：CoreSeek支持实时索引更新，这意味着新增或修改的数据可以立即反映...
3千字带你搞懂XXL - JOB任务调度平台
阿里云技术
10-20 570
思维导图 一、概述 在平时的业务场景中，经常有一些场景需要使用定时任务，比如： 时间驱动的场景：某个时间点发送优惠券，发送短信等等。 批量处理数据：批量统计上个月的账单，统计上个月销售数据等等。 固定频率的场景：每隔5分钟需要执行一次。 所以定时任务在平时开发中并不少见，而且对于现在快速消费的时代，每天都需要发送各种推送，消息都需要依赖定时任务去完成，应用非常广泛。 二、为什么需要任务调度平台 在Java中，传统的定时任务实现方案，比如Timer，Quartz等都或多或少存在一些问题：
3千字带你搞懂XXL-JOB任务调度平台
yehongzhi1994的博客
10-06 1755
什么是任务调度平台？为什么选择XXL-JOB？如何搭建XXL-JOB？看这篇文章你就懂了！
mysql 汉字拼音数据库.zip
05-29
常用的汉字，拼音数据库，基本包含了所有汉字，字段：汉字、繁体字、拼音、笔画、解释、更多等 里面有两个sql文件，一个包含了常用的汉字，另一个包含了几乎所有的汉字库
Mysql数据库实现某一汉字字段转拼音（全拼）
KnifeBlade的博客
06-21 7543
        （１）建立汉字拼音临时对照表：                CREATE TABLE IF NOT EXISTS `t_base_pinyin` (                      `pin_yin_` varchar(255) CHARACTER SET gbk NOT NULL,                      `code_` int(11) NOT NU...
Mysql数据库 汉字转拼音全拼
u011713224的专栏
02-13 4512
-- 创建汉字拼音对照临时表 CREATE TABLE IF NOT EXISTS `t_base_pinyin` ( `pin_yin_` varchar(255) CHARACTER SET gbk NOT NULL, `code_` int(11) NOT NULL, PRIMARY KEY (`code`) ) ENGINE=InnoDB DEFAULT CHARSE
mysql 数据库中将中文转化为拼音
chenludaniel的专栏
04-27 1488
1、创建拼音对照表 DROP TABLE IF EXISTS `t_base_pinyin`; CREATE TABLE `t_base_pinyin` ( `pin_yin_` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL, `code_` int(11) NOT NULL, PRIMARY KEY (`code_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = ...
mysql 拼音搜汉字,[转]在mysql 里实现查询汉字的拼音首字母
weixin_39949584的博客
03-17 447
php 里查询汉字的拼音首字母已经有很多参考的代码了。现在给出在mysql 里实现的， 测试环境是mysql-5.0.27-win321、建立拼音首字母资料表DROP TABLE IF EXISTS `pyk`;CREATE TABLE `pyk` (`PY` varchar(1) ,`HZ1` int ,`HZ2` int) ;INSERT I...
MySQL汉字转拼音方案
长安诗社社长@-梁瀚文- https://github.com/HevnChin https://gitee.com/HevnChin
10-12 366
【代码】MySQL汉字转拼音方案。
mysql利用数据库函数实现用拼音搜索中文的实现
Fiang-As-Dre的博客
08-10 3217
原文地址 1、创建表： CREATE TABLE IF NOT EXISTS `t_base_pinyin` ( `pin_yin_` VARCHAR (255) CHARACTER SET gbk NOT NULL, `code_` INT (11) NOT NULL, PRIMARY KEY (`code_`) ) ENGINE = INNODB DEFAULT CHARSET
mysql汉字拼音取法
wxj是好人
11-04 2714
下面的代码在gb2312字符集下测试了几个例子，都通过了。如果有问题，主要是在0x那块，因为这些16进制值是不同汉字拼音首字符开始的分界符，在不同字符集下，这些值亦有不同。我的环境在gb2312下，也许你的不是，但可以参考以下写法，但愿能帮助到各位。csdn以前支持发sql代码的，现在没有了，暂时用xml格式贴出来。再贴出我在navicat下写的程序源程序截图，帮助各位看官看清。CREATE DEFINER=`root`@`%` FUNCTION `getPinyin`(`in_string` varcha
mysql汉字转拼音函数
05-27
MySQL本身没有直接提供将汉字转换为拼音的函数，但我们可以通过自定义函数的方式来实现。下面给出一个简单的MySQL函数，可以将汉字转换为拼音： ``` DELIMITER $$ CREATE FUNCTION `pinyin`(str VARCHAR(255)) ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值