mysql 查看表字段以及驼峰转化

  驼峰转化

    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

删除函数

	drop function underlineToCamel; 

 演示

select underlineToCamel('CPTJFL_KHDX') from dual 

Mysql 自定义函数-下划线转驼峰_变胖的老哥的博客-CSDN博客

查询表字段

SELECT
	TABLE_SCHEMA AS '库名',
	TABLE_NAME AS '表名',
	COLUMN_NAME AS '列名',
	underlineToCamel ( COLUMN_NAME ) AS '驼峰',
	COLUMN_COMMENT AS '注释',
	ORDINAL_POSITION AS '列的排列顺序',
	COLUMN_DEFAULT AS '默认值',
	IS_NULLABLE AS '是否为空',
	DATA_TYPE AS '数据类型',
	CHARACTER_MAXIMUM_LENGTH AS '字符最大长度',
	NUMERIC_PRECISION AS '数值精度(最大位数)',
	NUMERIC_SCALE AS '小数精度',
	COLUMN_TYPE AS 列类型,
	COLUMN_KEY 'KEY',
	EXTRA AS '额外说明',
	1 AS '缺省自豪' 
FROM
	information_schema.`COLUMNS` 
WHERE
	TABLE_SCHEMA = 'ycpharmacy_db' 
	AND TABLE_NAME = 'work_user' 
ORDER BY
	TABLE_NAME,
	ORDINAL_POSITION;