1. mysql批量将表名小写换成大写
select CONCAT(‘RENAME TABLE ‘,TABLE_NAME,’ TO ‘,UPPER(TABLE_NAME),’;’) from information_schema.TABLES
where TABLE_SCHEMA=’sys’;
SQL快捷笔记
最新推荐文章于 2024-07-30 19:26:47 发布
1. mysql批量将表名小写换成大写
select CONCAT(‘RENAME TABLE ‘,TABLE_NAME,’ TO ‘,UPPER(TABLE_NAME),’;’) from information_schema.TABLES
where TABLE_SCHEMA=’sys’;