mysql存储过程 指针循环

CREATE PROCEDURE `tp1`()

BEGIN

//变量

DECLARE aid VARCHAR(50) ;

DECLARE stop INT DEFAULT 0;

//指针

DECLARE cur CURSOR FOR (SELECT id as aid from s_assetclassify);

//读取不到时改变stop，根据stop判断是否循环

declare CONTINUE HANDLER FOR SQLSTATE '02000' SET stop = null;

OPEN cur;
FETCH cur INTO aid;
WHILE ( stop is not null) DO
INSERT INTO table1 (name1,name2,name3)VALUES(aid,1,1);
FETCH cur INTO aid;
END WHILE;
close cur;
end