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('数据库名');