MySQL中文转拼音相关函数

最新推荐文章于 2025-02-20 07:00:00 发布

myth_gy

最新推荐文章于 2025-02-20 07:00:00 发布

阅读量680

点赞数

本文链接：https://blog.youkuaiyun.com/myth_g/article/details/119907863

版权

本文档详细介绍了如何创建一个用于存储汉字拼音的数据库t_base_pinyin，包含了各种常用汉字的拼音对照，并提供了两个函数：to_pinyin用于根据输入的汉字返回其拼音，以及fristPinyin和pinyin函数分别提取首字母和完整的拼音。这些工具对于处理中文字符编码和拼音转换非常实用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.转为全拼

新建数据库:



SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_base_pinyin
-- ----------------------------
DROP TABLE IF EXISTS `t_base_pinyin`;
CREATE TABLE `t_base_pinyin`  (
  `code_` int(255) NOT NULL,
  `pin_yin_` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
  PRIMARY KEY (`code_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of t_base_pinyin
-- ----------------------------
INSERT INTO `t_base_pinyin` VALUES (10254, 'zuo');
INSERT INTO `t_base_pinyin` VALUES (10256, 'zun');
INSERT INTO `t_base_pinyin` VALUES (10260, 'zui');
INSERT INTO `t_base_pinyin` VALUES (10262, 'zuan');
INSERT INTO `t_base_pinyin` VALUES (10270, 'zu');
INSERT INTO `t_base_pinyin` VALUES (10274, 'zou');
INSERT INTO `t_base_pinyin` VALUES (10281, 'zong');
INSERT INTO `t_base_pinyin` VALUES (10296, 'zi');
INSERT INTO `t_base_pinyin` VALUES (10307, 'zhuo');
INSERT INTO `t_base_pinyin` VALUES (10309, 'zhun');
INSERT INTO `t_base_pinyin` VALUES (10315, 'zhui');
INSERT INTO `t_base_pinyin` VALUES (10322, 'zhuang');
INSERT INTO `t_base_pinyin` VALUES (10328, 'zhuan');
INSERT INTO `t_base_pinyin` VALUES (10329, 'zhuai');
INSERT INTO `t_base_pinyin` VALUES (10331, 'zhua');
INSERT INTO `t_base_pinyin` VALUES (10519, 'zhu');
INSERT INTO `t_base_pinyin` VALUES (10533, 'zhou');
INSERT INTO `t_base_pinyin` VALUES (10544, 'zhong');
INSERT INTO `t_base_pinyin` VALUES (10587, 'zhi');
INSERT INTO `t_base_pinyin` VALUES (10764, 'zheng');
INSERT INTO `t_base_pinyin` VALUES (10780, 'zhen');
INSERT INTO `t_base_pinyin` VALUES (10790, 'zhe');
INSERT INTO `t_base_pinyin` VALUES (10800, 'zhao');
INSERT INTO `t_base_pinyin` VALUES (10815, 'zhang');
INSERT INTO `t_base_pinyin` VALUES (10832, 'zhan');
INSERT INTO `t_base_pinyin` VALUES (10838, 'zhai');
INSERT INTO `t_base_pinyin` VALUES (11014, 'zha');
INSERT INTO `t_base_pinyin` VALUES (11018, 'zeng');
INSERT INTO `t_base_pinyin` VALUES (11019, 'zen');
INSERT INTO `t_base_pinyin` VALUES (11020, 'zei');
INSERT INTO `t_base_pinyin` VALUES (11024, 'ze');
INSERT INTO `t_base_pinyin` VALUES (11038, 'zao');
INSERT INTO `t_base_pinyin` VALUES (11041, 'zang');
INSERT INTO `t_base_pinyin` VALUES (11045, 'zan');
INSERT INTO `t_base_pinyin` VALUES (11052, 'zai');
INSERT INTO `t_base_pinyin` VALUES (11055, 'za');
INSERT INTO `t_base_pinyin` VALUES (11067, 'yun');
INSERT INTO `t_base_pinyin` VALUES (11077, 'yue');
INSERT INTO `t_base_pinyin` VALUES (11097, 'yuan');
INSERT INTO `t_base_pinyin` VALUES (11303, 'yu');
INSERT INTO `t_base_pinyin` VALUES (11324, 'you');
INSERT INTO `t_base_pinyin` VALUES (11339, 'yong');
INSERT INTO `t_base_pinyin` VALUES (11340, 'yo');
INSERT INTO `t_base_pinyin` VALUES (11358, 'ying');
INSERT INTO `t_base_pinyin` VALUES (11536, 'yin');
INSERT INTO `t_base_pinyin` VALUES (11589, 'yi');
INSERT INTO `t_base_pinyin` VALUES (11604, 'ye');
INSERT INTO `t_base_pinyin` VALUES (11781, 'yao');
INSERT INTO `t_base_pinyin` VALUES (11798, 'yang');
INSERT INTO `t_base_pinyin` VALUES (11831, 'yan');
INSERT INTO `t_base_pinyin` VALUES (11847, 'ya');
INSERT INTO `t_base_pinyin` VALUES (11861, 'xun');
INSERT INTO `t_base_pinyin` VALUES (11867, 'xue');
INSERT INTO `t_base_pinyin` VALUES (12039, 'xuan');
INSERT INTO `t_base_pinyin` VALUES (12058, 'xu');
INSERT INTO `t_base_pinyin` VALUES (12067, 'xiu');
INSERT INTO `t_base_pinyin` VALUES (12074, 'xiong');
INSERT INTO `t_base_pinyin` VALUES (12089, 'xing');
INSERT INTO `t_base_pinyin` VALUES (12099, 'xin');
INSERT INTO `t_base_pinyin` VALUES (12120, 'xie');
INSERT INTO `t_base_pinyin` VALUES (12300, 'xiao');
INSERT INTO `t_base_pinyin` VALUES (12320, 'xiang');
INSERT INTO `t_base_pinyin` VALUES (12346, 'xian');
INSERT INTO `t_base_pinyin` VALUES (12359, 'xia');
INSERT INTO `t_base_pinyin` VALUES (12556, 'xi');
INSERT INTO `t_base_pinyin` VALUES (12585, 'wu');
INSERT INTO `t_base_pinyin` VALUES (12594, 'wo');
INSERT INTO `t_base_pinyin` VALUES (12597, 'weng');
INSERT INTO `t_base_pinyin` VALUES (12607, 'wen');
INSERT INTO `t_base_pinyin` VALUES (12802, 'wei');
INSERT INTO `t_base_pinyin` VALUES (12812, 'wang');
INSERT INTO `t_base_pinyin` VALUES (12829, 'wan');
INSERT INTO `t_base_pinyin` VALUES (12831, 'wai');
INSERT INTO `t_base_pinyin` VALUES (12838, 'wa');
INSERT INTO `t_base_pinyin` VALUES (12849, 'tuo');
INSERT INTO `t_base_pinyin` VALUES (12852, 'tun');
INSERT INTO `t_base_pinyin` VALUES (12858, 'tui');
INSERT INTO `t_base_pinyin` VALUES (12860, 'tuan');
INSERT INTO `t_base_pinyin` VALUES (12871, 'tu');
INSERT INTO `t_base

最低0.47元/天解锁文章