作用:把数据库的下划线命名改成骆驼命名
效果:sa_store_order_type 转化成 saStoreOrderType 如图
代码:
DELIMITER $$
DROP FUNCTION IF EXISTS doCamelName$$
CREATE FUNCTION doCamelName(name varchar(50)) RETURNS varchar(50)
BEGIN
DECLARE str VARCHAR(50) DEFAULT '';
declare v_max int unsigned default 5;
SET str=name;
while v_max >0 do
set str=REPLACE(str,SUBSTR(str,INSTR(str,'_'),2),SUBSTR(UPPER(SUBSTR(str,INSTR(str,'_'),2)),2));
set v_max=v_max-1;
end while;
return str;
END $$
DELIMITER ;
使用场景例子:对前端输出字段与注释
SELECT CONCAT(doCamelName(COLUMN_NAME),'=',COLUMN_COMMENT) from information_schema.`COLUMNS` where TABLE_NAME='******'