Pasted

CREATE PROCEDURE sp2 (x VARCHAR(5))BEGIN  DECLARE xname VARCHAR(5) DEFAULT 'bob';  DECLARE newname VARCHAR(5);  DECLARE xid INT;  DECLARE done TINYINT DEFAULT 0;  DECLARE cur1 CURSOR FOR SELECT xname, id FROM table1;  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;   OPEN cur1;  read_loop: LOOP    FETCH FROM cur1 INTO newname, xid;    IF done THEN LEAVE read_loop; END IF;    SELECT newname;  END LOOP;  CLOSE cur1;END;