【MySQL】全库调整表大小写语句

统一修改字段成小写+下划线的命名规则：

SQL实例：

SELECT
concat( 'alter table ', TABLE_NAME, ' change column ', COLUMN_NAME, ' ', LOWER( COLUMN_NAME ), ' ', COLUMN_TYPE, ' ', if(extra = 'auto_increment', extra, ''), if(COLLATION_NAME = 'utf8mb4_0900_ai_ci', ' CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci', ''), ' comment \'', COLUMN_COMMENT, '\';' ) AS '修改脚本'
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'dcs_coordinate_sit';

更改库名即可：

查询结果是一条条的改表语句，把SQL复制出来执行

保证单字段主键的自增不会被覆盖掉

if(extra = 'auto_increment',extra,''),

统一字段字符集标准：

if(COLLATION_NAME = 'utf8mb4_0900_ai_ci', ' CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci', ''),