例子:
DELIMITER $$ create PROCEDURE loopTables111 () BEGIN DECLARE done INT; DECLARE TableName VARCHAR(17); DECLARE TablesCursor CURSOR FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE SUBSTRING_INDEX(TABLE_NAME,'_',-1) = '20210826'; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; #DECLARE CONTINUE HANDLER FOR NOT FOUND SET Finished = TRUE; OPEN TablesCursor; MainLoop: LOOP FETCH TablesCursor INTO TableName; SELECT TableName; END LOOP; CLOSE TablesCursor; END$$ DELIMITER ;