Mysql 自定义函数-下划线转驼峰

最新推荐文章于 2024-04-12 11:18:19 发布

brave_zhao

最新推荐文章于 2024-04-12 11:18:19 发布

阅读量667

点赞数

分类专栏： mysql

原文链接：https://blog.csdn.net/qq_43565104/article/details/108821559

版权

mysql 专栏收录该内容

73 篇文章 0 订阅

订阅专栏

这个博客分享了一个MySQL自定义函数，用于将下划线分隔的字符串转换为驼峰式命名。函数通过一系列的REPLACE操作，将每个下划线后的字母替换为其大写形式，从而实现从`underline_to_camel`到`underlineToCamel`的转换，对于数据库字段或编程中的命名规范转换非常有用。

摘要由CSDN通过智能技术生成

CREATE FUNCTION `underlineToCamel`(paramString VARCHAR(200)) RETURNS varchar(200) CHARSET utf8
DETERMINISTIC
begin
               set paramString = LOWER(paramString);
       set paramString = replace(paramString, '_a', 'A');
set paramString = replace(paramString, '_b', 'B');
set paramString = replace(paramString, '_c', 'C');
set paramString = replace(paramString, '_d', 'D');
set paramString = replace(paramString, '_e', 'E');
set paramString = replace(paramString, '_f', 'F');
set paramString = replace(paramString, '_g', 'G');
set paramString = replace(paramString, '_h', 'H');
set paramString = replace(paramString, '_i', 'I');
set paramString = replace(paramString, '_j', 'J');
set paramString = replace(paramString, '_k', 'K');
set paramString = replace(paramString, '_l', 'L');
set paramString = replace(paramString, '_m', 'M');
set paramString = replace(paramString, '_n', 'N');
set paramString = replace(paramString, '_o', 'O');
set paramString = replace(paramString, '_p', 'P');
set paramString = replace(paramString, '_q', 'Q');
set paramString = replace(paramString, '_r', 'R');
set paramString = replace(paramString, '_s', 'S');
set paramString = replace(paramString, '_t', 'T');
set paramString = replace(paramString, '_u', 'U');
set paramString = replace(paramString, '_v', 'V');
set paramString = replace(paramString, '_w', 'W');
set paramString = replace(paramString, '_x', 'X');
set paramString = replace(paramString, '_y', 'Y');
set paramString = replace(paramString, '_z', 'Z');
set paramString = replace(paramString, '_', '');
RETURN paramString;
   end