MysqlConnection conn = new mysqlConnection(connectStr); conn.Open(); MysqlCommand cmd = conn.CreateCommand(); const stri
MysqlConnection conn = new mysqlConnection(connectStr);
conn.Open();
MysqlCommand cmd = conn.CreateCommand();
const string insertHeader="INSERT INTO `local_data`(`point_id`,`path_name`,`point_value`,`store_time`) VALUES";
for (int i = 0; i < points.Count; i++)
{
if (i%50 == 0)
{
cmd.CommandText=insertHeader;
}
if (cmd.CommandText !=insertHeader)
{
cmd.CommandText +=",";
}
cmd.CommandText += string.Format("({0},"{1}",{2},"{3}")",
points[i].Point_ID,
points[i].Path_Name,
points[i].Point_Value,
points[i].Store_Time);
if((i > 0 && i % 50==0)||i== points.Count-1)
{
sqlList.Add(cmd.CommandText);
cmd.ExecuteNonQuery();
}
}
cmd.Dispose();
conn.Close();
--结束END--
本文标题: 分组批量插入数据算法
本文链接: https://www.lsjlt.com/news/2422.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-28
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0