mysql表名字段名批量改小写

最新推荐文章于 2024-04-26 13:29:49 发布

qq_16550037

最新推荐文章于 2024-04-26 13:29:49 发布

阅读量426

点赞数

文章标签： mysql 数据库 database

本文链接：https://blog.csdn.net/qq_16550037/article/details/122143508

版权

导出sql 如

CREATE TABLE `act_evt_log` (
  `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
  `TYPE_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `USER_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `DATA_` longblob,
  `LOCK_OWNER_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_PROCESSED_` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`LOG_NR_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

要在Vim中执行此操作，请打开文件，然后输入以下命令：
```
:%s/`\(\w\+\)`/\L&/g
```

保存即可

CREATE TABLE `act_evt_log` (
  `log_nr_` bigint(20) NOT NULL AUTO_INCREMENT,
  `type_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `proc_def_id_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `proc_inst_id_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `execution_id_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `task_id_` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `time_stamp_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `user_id_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `data_` longblob,
  `lock_owner_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `lock_time_` timestamp(3) NULL DEFAULT NULL,
  `is_processed_` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`log_nr_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;