存储过程

表中插入 10 万行记录

delimiter ;;
create procedure idata()
begin
  declare i int;
  set i=1;
  while(i<=100000)do
    insert into t values(i, i, i);
    set i=i+1;
  end while;
end;;
delimiter ;
call idata();

![炫酷,炫彩,耀眼](http://cdn-hw-static.shanhutech.cn/bizhi/staticwp/202209/b631dc50462aeb15da154da91d99558at01007abd70cad4eb97.jpg