drop function if exists loopfunction
//

create function loopfunction() returns VARCHAR(20)
begin

   declare l_loop int default 0; 
      
   loop1: loop
   
    set l_loop := l_loop + 1;
    
    if l_loop >= 10 then 
       leave loop1;
    end if;

   end loop loop1;  

   return concat('We looped ',l_loop,' times');

end
//