SELECT CONCAT('RENAME TABLE ',TABLE_NAME,' TO ',UPPER(TABLE_NAME),';') FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '数据库的名字';
MySQL将库中所有表的表名转为大写
于 2023-12-07 20:47:45 首次发布
SELECT CONCAT('RENAME TABLE ',TABLE_NAME,' TO ',UPPER(TABLE_NAME),';') FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '数据库的名字';