drop function if exists repeatfunction
//
create function repeatfunction() returns int
begin

   declare l_repeat_count int default 0;
	   
   repeat 
   
      set l_repeat_count = l_repeat_count + 1;	      
   	
   until l_repeat_count = 10 end repeat; 

   return l_repeat_count;

end
//