mysql脚本写法

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后可以不用分号，本身就是分号。