使用如下代码向MySQL中的一行添加不同列的数据,结果却如图所示,我是哪里错了吗??
string sqlInsert = "insert into t1 (wavelength) values('" + tmpData + "')";
listSqlCom.Add("insert into t1 (time) values('" + System.DateTime.Now.ToString("yyyyMMdd_HHmmss").ToString() + "')");
listSqlCom.Add("insert into t1 (number) values('" + FBGNums.ToString() + "')");
listSqlCom.Add(sqlInsert);
for (int i = 0; i < listSqlCom.Count; i++)
{
MySqlCommand cmd = ms.getSqlCommand(listSqlCom.ElementAt(i), mysql);
cmd.ExecuteNonQuery();
}
//ms.dealMultiCom(listSqlCom);
mysql.Close();
listSqlCom.Add("insert into t1 (number) values('" + FBGNums.ToString() + "')");
->
listSqlCom.Add("update t1(number) values('" + FBGNums.ToString() + "') where time='" + System.DateTime.Now.ToString("yyyyMMdd_HHmmss").ToString() + "'");