Как полностью удалить ячейку в mysql с помощью c#?

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

using MySql.Data.MySqlClient;

string connectionString = "Server=localhost;Database=mydatabase;Uid=myusername;Pwd=mypassword;";
string query = "DELETE FROM mytable WHERE id = @id;";

using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    MySqlCommand command = new MySqlCommand(query, connection);
    command.Parameters.AddWithValue("@id", 3);
    try
    {
        connection.Open();
        int result = command.ExecuteNonQuery();
        Console.WriteLine("Affected rows: " + result);
    }
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message);
    }
}