使用mysql的存储过程while循环添加数据

\d //
create procedure p1()
begin
set @i=0;
while @i<1000 do
insert into myadmin_user values(null,concat('user',@i),'123456',concat('1370138',@i),1,20,'2020-09-02 18:10:02','2020-09-02 18:10:02',0,'/static/myadmin/img/user05.png');
set @i=@i+1;
end while;
end;
//




call p1()//
\d;