procedure_cursor_update.md

DROP PROCEDURE IF EXISTS dorepeat

CREATE PROCEDURE dorepeat()
BEGIN
DECLARE someId INT;
DECLARE city CHAR(50);
DECLARE done INT DEFAULT FALSE;
DECLARE cur1 CURSOR FOR select id_cidade,cidade from cepbr_cidade ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;     

OPEN cur1;

read_loop: LOOP

FETCH cur1 INTO someId, city;

update cepbr_cidade set nome_sem_acento = fn_remove_accents(city) where id_cidade = someId;

IF done THEN

CLOSE cur1;
  LEAVE read_loop;
END IF;

END LOOP read_loop;
END;

CALL dorepeat();