批量将表名改成大写-UPPER
SELECT
concat( 'alter table ', TABLE_NAME, ' rename to ', UPPER( TABLE_NAME ), ';' ) AS '修改脚本'
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = 'bedev'
批量将表名改成小写-LOWER
SELECT
concat( 'alter table ', TABLE_NAME, ' rename to ', LOWER( TABLE_NAME ), ';' ) AS '修改脚本'
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = 'bedev'