mysql 嵌套游标的有关问题

mysql 嵌套游标的问题

SQL code

BEGINDECLARE p VARCHAR(25);DECLARE pid int;DECLARE c varchar(25);DECLARE cid int;declare ct varchar(25);declare ctid int;declare t varchar(25);declare v varchar(25);DECLARE l_done INT DEFAULT  0;  DECLARE cu_p CURSOR FOR SELECT Name FROM province;    DECLARE cu_c CURSOR FOR SELECT Name FROM city ProvinceID = pid;#这个where条件是根据上一轮的PID来进行查询的,但是好像嵌套的时候无法这样使用.    DECLARE CONTINUE HANDLER FOR NOT FOUND SET l_done=1;  OPEN cu_p;  cu_p_loop: LOOP    FETCH cu_p INTO p;        insert into china(`name`,`parentid`) values (p,1);        select LAST_INSERT_ID() INTO pid;                #我要怎么才能把这个自增ID放到下一个游标循环中使用            OPEN cu_c;                cu_c_loop:LOOP                FETCH cu_c into c;                    #插入市级                    INSERT into china(`name`,parentid) values(c,pid);                end loop;            CLOSE cu_c;    end loop;  CLOSE cu_p;END