use test_db;
delimiter $$
drop procedure if exists sp_dowhile$$
create procedure sp_dowhile()
begin
set @i=3;
while @i<100
do
select * from student;
set @i=@i+1;
END while;
end $$
delimiter ;
call test_db.sp_dowhile;
use test_db;
delimiter $$
drop procedure if exists sp_dowhile$$
create procedure sp_dowhile()
begin
set @i=3;
while @i<100
do
select * from student;
set @i=@i+1;
END while;
end $$
delimiter ;
call test_db.sp_dowhile;