drop function if exists loopfunction
//

create function loopfunction() returns VARCHAR(50)
begin

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

    set l_loop2 := l_loop2 + 1;

   end loop loop1;  

   return concat('We looped ',l_loop,' times but loop2 only got to ',l_loop2);

end
//