批量将表名改为小写
region为库名
SELECT
concat( 'alter table ', TABLE_NAME, ' rename to ', LOWER( TABLE_NAME ), ';' ) AS '修改脚本'
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = 'region'
批量将列名改为小写
SELECT
concat( 'alter table ', TABLE_NAME, ' change column ', COLUMN_NAME, ' ', LOWER( COLUMN_NAME ), ' ', COLUMN_TYPE, ' comment '', COLUMN_COMMENT, '';' ) AS '修改脚本'
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'region'
然后再执行打印的语句