MYSQL将表名称修改成大写的存储过程
本文为大家分享了MYSQL将表名称修改成大写的存储过程，具体内容如下
1.条件：
1.1Mysql设置对大小写敏感
2.执行下述存储过程：
#calluppercase('库名')
DROPPROCEDUREIFEXISTSuppercase;
CREATEPROCEDUREuppercase(INdbnameVARCHAR(200))
BEGIN
DECLAREdoneINTDEFAULT0;
DECLAREoldnameVARCHAR(200);
DECLAREcurCURSORFORSELECTtable_nameFROMinformation_schema.TABLESWHEREtable_schema=dbname;
DECLARECONTINUEHANDLERFORNOTFOUNDSETdone=1;
OPENcur;
REPEAT
FETCHcurINTOoldname;
SET@newname=UPPER(oldname);
SET@isNotSame=@newname<>BINARYoldname;
IFNOTdone&&@isNotSameTHEN
SET@SQL=CONCAT('renametable`',oldname,'`to`',LOWER(@newname),'_tmp`');
PREPAREtmpstmtFROM@SQL;
EXECUTEtmpstmt;
SET@SQL=CONCAT('renametable`',LOWER(@newname),'_tmp`to`',@newname,'`');
PREPAREtmpstmtFROM@SQL;
EXECUTEtmpstmt;
DEALLOCATEPREPAREtmpstmt;
ENDIF;
UNTILdoneENDREPEAT;
CLOSEcur;
END
3.执行一下语句
calluppercase('库名');
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持毛票票。