MySQL将表名称修改成大写的存储过程

MySQL将表名称修改成大写的存储过程1. 条件： 1.1 Mysql设置对大小写敏感2. 执行下述存储过程：#call uppercase（"库名"）
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）; SET @isNotSame = @newname <> BINARY oldname;

IF NOT done && @isNotSame THEN

SET @SQL = CONCAT（"rename table `",oldname,"` to `", LOWER（@newname）, "_tmp` "）;

PREPARE tmpstmt FROM @SQL;

EXECUTE tmpstmt;
SET @SQL = CONCAT（"rename table `",LOWER（@newname）,"_tmp` to `",@newname, "`"）;

PREPARE tmpstmt FROM @SQL;

EXECUTE tmpstmt;

DEALLOCATE PREPARE tmpstmt;

END IF;

UNTIL done END REPEAT;

CLOSE cur;

END3. 执行一下语句call uppercase（"库名"）;本文永久更新链接地址