procedure mysql update with cursor

procedure_cursor_update.md

DROP PROCEDURE IF EXISTS dorepeat

CREATE PROCEDURE dorepeat()
BEGIN
DECLARE someId INT;
DECLARE neighborhood LONGTEXT;
DECLARE done INT DEFAULT FALSE;
DECLARE cur1 CURSOR FOR select id_bairro,bairro from cepbr_bairro ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;     

OPEN cur1;

read_loop: LOOP

FETCH cur1 INTO someId, neighborhood;

update cepbr_bairro set nome_sem_acento = fn_remove_accents(neighborhood) where id_bairro = someId;

IF done THEN

CLOSE cur1;
  LEAVE read_loop;
END IF;

END LOOP read_loop;
END;

CALL dorepeat();