• + 0 comments

    my sql

    delimiter $$ 
    create procedure loops()
    begin
        declare counter int default 20;
        
        while counter >0 do 
            select repeat('* ',counter);
            set counter = counter -1 ; 
            
        end while ;
    end $$ 
    
    delimiter ; 
    
    call loops();