56,679
社区成员
发帖
与我相关
我的任务
分享
D:\MySQL55\bin>MYSQL -uroot -pZWTL AA<R:\TEMP\A.TXT
D:\MySQL55\bin>
mysql> USE AA;
Database changed
mysql> SOURCE R:/TEMP/A.TXT;
Query OK, 0 rows affected (0.11 sec)
mysql>
A.TXT
delimiter //
create procedure mypro1()
begin
declare i int ;
declare pos int;
set i = 0;
set pos = 10002;
while pos<10005 do
insert into s(stu_num,stu_name,stu_address)values(pos,'xy','北京市');
set i = i+1;
set pos = pos+1;
end while;
end//
delimiter ;