navicat创建mysql存储过程,创建测试数据

创建存储过程: create procedure test() begin declare i int; set i=1; while i<=10 do insert into admin(id,name) values(i,concat('aaa',i)); set i=i+1; end while; end 调用 delimiter; call test();