delimiter //
create procedure mypro4()
begin
declare i int ;
declare pos int;
set i = 0;
set pos = 10002;
while pos<10005 do
insert into s(stu_num,name)values(pos,'xy');
set i = i+1;
set pos = pos+1;
end while;
end//
delimiter ;
source c:/1.txt
begin, end后可以不用分号,本身就是分号。