mysql表名字段名批量改小写

  1. 导出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;
    

  2. 要在Vim中执行此操作,请打开文件,然后输入以下命令:
    :%s/`\(\w\+\)`/\L&/g
  3. 保存即可
    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;

上一篇:python tips003 ——DataLoader的collate_fn参数使用详解


下一篇:对于MySQL远程连接中出现的一个问题总结