1.C#
MySqlParameter[] parameters = {
new MySqlParameter("?num", 4)};
int result = MySqlHelper.ExecuteNonQuery(MySqlHelper.DBConnectionString, CommandType.StoredProcedure, "proc_addVirtualyhUser", parameters);
2.proc
select * from User;
-- 删除proc
drop procedure proc_addVirtualyhUser;
-- 创建proc
delimiter //
create procedure proc_addVirtualyhUser(in num bigint)
begin
-- declare num int;
declare account varchar(64);
-- set num=65000;
while num <= 5 do
set account=CONCAT('hx_',num);
insert into User(UserId, Name,Password) values(num,account,'123456');
set num=num+1;
end while;
end//
delimiter ; -- // 先把结束符 回复为;
-- 执行proc
call proc_addVirtualyhUser(2);