循环插入数据sql

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;