create procedure dowhile() begin declare n int; set n=1; while n=1000 do insert into hasindex(num) values (n); set n=n1; end while; end; call dowhile();
create procedure dowhile()
begin
declare n int;
set n=1;
while ndo
insert into hasindex(num) values (n);
set n=n+1;
end while;
end;
call dowhile();