简单示例:
mysql> CREATE PROCEDURE lj()
-> BEGIN
-> DECLARE done INT DEFAULT 0;
-> DECLARE v_a varchar(100);
-> DECLARE cur1 CURSOR FOR SELECT f1 FROM tt;
-> DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
-> set @sqlstmt='';
-> OPEN cur1;
-> FETCH cur1 INTO v_a;
-> WHILE done=0 DO
-> set @sqlstmt=concat(@sqlstmt,v_a);
-> FETCH cur1 INTO v_a;
-> END WHILE;
-> END;