当前位置：首页 > article >正文

mysql字段名批量大小写转换

article 2025/2/3 19:20:59

`module_name` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT ‘生成模块名’,

`business_name` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT ‘生成业务名’,

`function_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT ‘生成功能名’,

`function_author` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT ‘生成功能作者’,

`gen_type` char(1) COLLATE utf8mb4_bin DEFAULT ‘0’ COMMENT ‘生成代码方式（0zip压缩包 1自定义路径）’,

`gen_path` varchar(200) COLLATE utf8mb4_bin DEFAULT ‘/’ COMMENT ‘生成路径（不填默认项目路径）’,

`options` varchar(1000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT ‘其它生成选项’,

`create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT ‘’ COMMENT ‘创建者’,

`create_time` datetime DEFAULT NULL COMMENT ‘创建时间’,

`update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT ‘’ COMMENT ‘更新者’,

`update_time` datetime DEFAULT NULL COMMENT ‘更新时间’,

`remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT ‘备注’,

PRIMARY KEY (`table_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT=‘代码生成业务表’;

生成列名小写转大写的语句

SELECT

concat( 'alter table ', ‘gen_table_copy1’, ’ change column ‘, COLUMN_NAME, ’ ‘, LOWER( COLUMN_NAME ), ’ ‘, COLUMN_TYPE, ’ comment \’’, COLUMN_COMMENT, ‘\’;’ ) AS ‘修改脚本’

FROM

information_schema.COLUMNS

WHERE

TABLE_NAME = ‘gen_table_copy1’;

执行结果:

导出结果直接执行即可

示例:

alter table gen_table_copy1 change column table_id TABLE_ID bigint(20) comment ‘编号’;

alter table gen_table_copy1 change column table_name TABLE_NAME varchar(200) comment ‘表名称’;

alter table gen_table_copy1 change column table_comment TABLE_COMMENT varchar(500) comment ‘表描述’;

alter table gen_table_copy1 change column sub_table_name SUB_TABLE_NAME varchar(64) comment ‘关联子表的表名’;

alter table gen_table_copy1 change column sub_table_fk_name SUB_TABLE_FK_NAME varchar(64) comment ‘子表关联的外键名’;

alter table gen_table_copy1 change column class_name CLASS_NAME varchar(100) comment ‘实体类名称’;

alter table gen_table_copy1 change column tpl_category TPL_CATEGORY varchar(200) comment ‘使用的模板（crud单表操作 tree树表操作）’;

alter table gen_table_copy1 change column package_name PACKAGE_NAME varchar(100) comment ‘生成包路径’;

alter table gen_table_copy1 change column module_name MODULE_NAME varchar(30) comment ‘生成模块名’;

alter table gen_table_copy1 change column business_name BUSINESS_NAME varchar(30) comment ‘生成业务名’;

alter table gen_table_copy1 change column function_name FUNCTION_NAME varchar(50) comment ‘生成功能名’;

alter table gen_table_copy1 change column function_author FUNCTION_AUTHOR varchar(50) comment ‘生成功能作者’;

alter table gen_table_copy1 change column gen_type GEN_TYPE char(1) comment ‘生成代码方式（0zip压缩包 1自定义路径）’;

alter table gen_table_copy1 change column gen_path GEN_PATH varchar(200) comment ‘生成路径（不填默认项目路径）’;
alter table gen_table_copy1 change column options OPTIONS varchar(1000) comment ‘其它生成选项’;
alter table gen_table_copy1 change column create_by CREATE_BY varchar(64) comment ‘创建者’;
alter table gen_table_copy1 change column create_time CREATE_TIME datetime comment ‘创建时间’;
alter table gen_table_copy1 change column update_by UPDATE_BY varchar(64) comment ‘更新者’;
alter table gen_table_copy1 change column update_time UPDATE_TIME datetime comment ‘更新时间’;
alter table gen_table_copy1 change column remark REMARK varchar(500) comment ‘备注’;

查看全文

http://www.kler.cn/a/530137.html