mysql 批量插入guid_MYSQL批量插入(C#)

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingMySql.Data.MySqlClient;usingSystem.Diagnostics;namespaceMySqlTest

{classProgram

{static void Main(string[] args)

{

String connstr= "server=localhost;database=unamed;user=root;password=123456;";

Stopwatch watch= newStopwatch();

StringBuilder sb= newStringBuilder();

String sql0= "insert into tb_test(field1,field2,field3,field4,field5,field6,field7,field8,field9,field10) values";

sb.Append(sql0);

Random rnd= newRandom();

List parmList = new List();for (int index = 0; index < 1700; index++)

{

String f1= Guid.NewGuid().ToString().Replace("-", "");

String f2= Guid.NewGuid().ToString().Replace("-", "");

String f3= Guid.NewGuid().ToString().Replace("-", "");int f4 =rnd.Next();

DateTime f5=DateTime.Now.AddDays(rnd.Next(index));

sb.Append(String.Format("(@field1_index{0},@field2_index{0},@field3_index{0},@field4_index{0},@field5_index{0},@field6_index{0},@field7_index{0},@field8_index{0},@field9_index{0},@field10_index{0}),",

index.ToString()));

parmList.Add(new MySqlParameter("field1_index" +index.ToString(), f1));

parmList.Add(new MySqlParameter("field2_index" +index.ToString(), f2));

parmList.Add(new MySqlParameter("field3_index" +index.ToString(), f3));

parmList.Add(new MySqlParameter("field4_index" +index.ToString(), f4.ToString()));

parmList.Add(new MySqlParameter("field5_index" +index.ToString(), f5));

parmList.Add(new MySqlParameter("field6_index" + index.ToString(), f1 + f2 +f3));

parmList.Add(new MySqlParameter("field7_index" + index.ToString(), f1 + f2 +f3));

parmList.Add(new MySqlParameter("field8_index" + index.ToString(), f1 + f2 +f3));

parmList.Add(new MySqlParameter("field9_index" + index.ToString(), f1 + f2 +f3));

parmList.Add(new MySqlParameter("field10_index" + index.ToString(), 1));

}

sb.Remove(sb.Length- 1, 1);

String sql=sb.ToString();

watch.Start();int effectedRows =MySqlHelper.ExecuteNonQuery(connstr, sql, parmList.ToArray());

watch.Stop();

Console.WriteLine(effectedRows.ToString()+ "行受影响");

Console.WriteLine("总计用时" +watch.Elapsed.ToString());

Console.ReadLine();

}

}

}