#call uppercase('库名')
 DROP PROCEDURE IF EXISTS uppercase;
 ))
 BEGIN  

 ;   

 );   

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

 ;   

 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;   

 END    

call uppercase('库名');