VS2022 删除MySQL数据

 

//删除----------------------------------------------------------------------------------------------
string sqldelete = " DELETE FROM bookshop WHERE 编号 = 6 ";

using (MySqlCommand command = new MySqlCommand(sqldelete, connection))
{
int rowsAffected = command.ExecuteNonQuery();

Console.WriteLine("\n");
Console.WriteLine( "\n" +$"{rowsAffected} 条数据已删除！");
}

 

删除成功