已經測試，創建并運行下面的存儲過程可以循環添加數據：

create procedure dowhile()

begin

declare i int default 0;

start transaction;

while i

insert into users(userId,userName,userPwd) values(null,concat('s00',i),123456);

set i=i+1;

end while;

commit;

end;

delimiter;