怎么用heidisql 写mysql 5.1 的存储过程

例子:

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 ;

 

CategoriesUncategorized