详细代码:
string sqlconst = "server=localhost;user=root;database=mytestsql;port=3306;password=root;";
MySqlConnection connect = new MySqlConnection(sqlconst);
connect.Open();
Console.WriteLine("成功链接mysql...");
MySqlCommand command = new MySqlCommand("update testuserid set testint=999 where Id=100002", connect);
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
string error_msg = ex.Message;
Console.WriteLine("修改数据失败...");
}
connect.Close();