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 ;
第二题用if exists判断第三题也是循环,累加求平均