更新时间:2022-10-27 23:02:44
该评论者得到了我的投票。是的我也可以使用BULK INSERT
。如果您不想要BULK INSERT,那么构建单个查询&执行一次(检查以下链接)。
使用单个数据将多条记录插入MySQL查询 [ ^ ]
Pls help me in this problem
how can i insert fast in for loop using paramertizered query
<pre lang="c#">
for(int i=0;i<=10000;i++)
{
string qry="insert into demo(id,text,name,age,address)values(@id,@text,@name,@age,@address)";
MySqlParameter idP=new MySqlParameter(@id",0);
MySqlParameter textP=new MySqlParameter(@text,slipno/2012-13/);
MySqlParameter nameP=new MySqlParameter(@name,Ram);
MySqlParameter ageP=new MySqlParameter(@age,33);
MySqlParameter addressP=new MySqlParameter(@address",house no#01,new street,New delhi,India);
MySqlParameter[]p={idP,textP,nameP,ageP,addressP};
MysqlHelper.executenonquery(connecionstring,qry,p);
}
That commenter got my vote. Yes I too go withBULK INSERT
. If you don't want BULK INSERT then build single query & execute once(check the below link).
Insert multiple records into MySQL with a single query[^]