MySQL如何批量将表名改成大写或小写

1,189 阅读1分钟

批量将表名改成大写-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'