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 |
+------+
*/
存储过程:repeat
最新推荐文章于 2024-07-28 21:35:44 发布