– 驼峰转下划线 (笨方法 :一个一个转变)
CREATE FUNCTION camelToUnderline
(paramString VARCHAR(200)) RETURNS varchar(200) CHARSET utf8
DETERMINISTIC
begin
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
mysql中字段值的驼峰和下划线互相转化
最新推荐文章于 2024-09-10 10:08:10 发布
本文提供了两个MySQL自定义函数,分别用于将驼峰式命名的字段值转换为下划线分隔的形式,以及将下划线分隔的字段值转换为驼峰式命名。这两个函数通过replace()函数逐个替换字符实现转换。
摘要由CSDN通过智能技术生成