存储过程:repeat

drop table if exists t;

create table t (s1 int);  
  
insert into t values (5);  

select * from t;

-- --------------------------------------------------

drop procedure if exists p15;

delimiter //

 
create procedure p15 ()  
begin  
  declare v int;  
  set v = 0;  
  repeat  
    insert into t values (v);  
    set v = v + 1;  
    until v >= 5  
  end repeat;  
end; //  
 

delimiter ;

call p15();

select * from t;

/*
+------+
| s1   |
+------+
|    5 |
|    0 |
|    1 |
|    2 |
|    3 |
|    4 |
+------+
*/