使用存储过程实现循环插入100条记录

mysql> delimiter $$

mysql> create procedure p3()

-> MODIFIES SQL DATA

-> BEGIN

-> set @i=0;

-> set @max=100;

-> while @i<@max do

-> insert into user values (@i);

-> set @i = @i + 1;

-> end while;

-> end $$