Mysql 数据库表名批量改为大写

DELIMITER // 

DROP PROCEDURE IF EXISTS uppercase // 

CREATE PROCEDURE uppercase(IN dbname VARCHAR(200)) 

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 // 

DELIMITER ; 
#调用存储过程
#call uppercase('数据库名');
#