存储过程:while

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 |+------+*/