drop table if exists t;
create table t (s1 int);
insert into t values (5);
select * from t;
-- --------------------------------------------------
drop procedure if exists p14;
delimiter //
create procedure p14 ()
begin
declare v int;
set v = 0;
while v < 5 do
insert into t values (v);
set v = v + 1;
end while;
end; //
delimiter ;
call p14();
select * from t;
/*
+------+
| s1 |
+------+
| 5 |
| 0 |
| 1 |
| 2 |
| 3 |
| 4 |
+------+
*/
存储过程:while
最新推荐文章于 2024-07-27 21:51:48 发布