mysql更新多条数据6_Mysql一次更新多条数据

根据不同的ID更新ID对应条的Code,Name,Value,Type：

string updateSqlString = " update serverconfigdata set ";

string updateSqlCode = " Code = CASE ID ";

string updateSqlName = " Name = CASE ID ";

string updateSqlValue = " Value = CASE ID ";

string updateSqlType = " Type = CASE ID ";

foreach (ServerConfigData sc in scList)

{

if(!string.IsNullOrEmpty(sc.ID))

{

//updateSqlString = $" update tablename set Code = '{sc.Code}',Name = '{sc.Name}',Value = '{sc.Value}',Type = '{sc.Type}' where Code = '{sc.Code}'; ";

//DataTable updatedt = mySQLConn.ExecuteDataTable(updateSqlString);

updateSqlCode += $" When {sc.ID} Then '{sc.Code}' ";

updateSqlName += $" When {sc.ID} Then '{sc.Name}' ";

updateSqlValue += $" When {sc.ID} Then '{sc.Value}' ";

updateSqlType += $" When {sc.ID} Then '{sc.Type}' ";

updateIDS += $"{sc.ID},";

}

else

{

insertSqlDatas += $" ('{sc.Code}','{sc.Name}','{sc.Value}','{sc.Type}'),";

}

}

updateSqlCode += " END ";

updateSqlName += " END ";

updateSqlValue += " END ";

updateSqlType += " END ";