mysql腳本查詢,如何使用Mysql腳本插入數據流到數據庫內?
已經測試,創建并運行下面的存儲過程可以循環添加數據:
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;