delimiter // create procedure insrt20 () begin declare i int default 1; while i <=20 do insert into stuinfo (stuid, stuname, stusex) values (i,'aaa', 'male'); set i=i+2; end while; end // delimiter ;
othername没有赋值,无论输入值是多少结果都是一样的