[遍历表]我的第一个mysql存储过程

DELIMITER$$
/*更改discuz数据库中每个表的字符集为utf8，校对规则为utf8_bin1:442007-11-4*/
DROPPROCEDUREIFEXISTS`discuz`.`qifei`$$
CREATEDEFINER=`root`@`localhost`PROCEDURE`qifei`()
BEGIN
DECLAREdoneINTDEFAULT0;
DECLAREaVARCHAR(20);
DECLARErsCURSORFOR
SELECT`TABLE_NAME`FROMinformation_schema.`TABLES`where`TABLE_SCHEMA`='discuz';
DECLARECONTINUEHANDLERFORSQLSTATE'02000'SETdone=1;
openrs;
REPEAT
FETCHrsINTOa;
SET@s=CONCAT('
ALTERTABLE',a,'
DEFAULTCHARACTERSETutf8
DEFAULTCOLLATEutf8_bin');
PREPAREstmtFROM@s;
EXECUTEstmt;
UNTILdoneENDREPEAT;
CLOSErs;
END$$
DELIMITER;

涉及知识点：变量定义、预处理语句、系统表、游标、循环语句、字符串函数