mysql 批量改表名为大写

mysql如何批量将数据库的表名改成大写

BEGIN 

DECLARE done INT DEFAULT 0; 

DECLARE oldname VARCHAR(200); 

DECLARE cur CURSOR FOR SELECT table_name FROM information_schema.TABLES WHERE table_schema = dbname; 

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; 

OPEN cur; 

REPEAT 

FETCH cur INTO oldname; 

SET @newname = UPPER(oldname); 

#IF newname equals to oldname, do nothing; 
#select 'a' <> 'A'; -> 0 
#select 'a' <> BINARY 'A'; -> 1 
SET @isNotSame = @newname <> BINARY oldname; 

IF NOT done && @isNotSame THEN 

SET @SQL = CONCAT('rename table ',oldname,' to ',@newname); 

PREPARE tmpstmt FROM @SQL; 

EXECUTE tmpstmt; 

DEALLOCATE PREPARE tmpstmt; 

END IF; 

UNTIL done END REPEAT; 

CLOSE cur; 

END

#调用存储过程 

call uppercase('TEST');

#TEST为你想要修改的数据库的名称

最后

以上就是悦耳洋葱最近收集整理的关于mysql 批量改表名为大写的全部内容，更多相关mysql内容请搜索靠谱客的其他文章。