c# - SQL 不会更新数据库

Question

我检查过的这个 sql 语句是有效的:

UPDATE faxcomplete SET DATE= curdate() WHERE DATE='0000-00-00'

当我运行代码时，它不会更新数据库。我是初学者，我不知道如何检查是否有问题:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace ConsoleApplication1
{
  class Program
  {
    static void Main(string[] args)
    {
      string MyConString = "SERVER=localhost;" +
                           "DATABASE=webboard;" +
                           "UID=root;" +
                           "PASSWORD='';";
      MySqlConnection connection = new MySqlConnection(MyConString);
      MySqlCommand command = connection.CreateCommand();
      MySqlDataReader Reader;
      command.CommandText = "UPDATE `faxcomplete` SET `DATE`= curdate() WHERE `DATE`='0000-00-00'";
    }
  }

Answer 1

尝试在您的命令上调用 ExecuteNonQuery。